Advertisement

Check permissions given to a database role

Share the blog:

As a Database Administrator, you may need to identify the permissions that have been granted to a user-created database role. To begin, use the query provided by Microsoft to list all of the database roles that are currently present in the database.

Ref. sys.database_role_members

The following query returns the members of the database roles.

Members of the database roles
Members of the database roles

Now to check the list of all Permissions for a given user DB role use the below query

Advertisement

Facebook Comments Box
Share the blog:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Advertisement