Using DMV to identify members roles

,

Some times is necessary retrieve a list of members of the roles of a database. Doing this is simple, using the DMV sys.database_role_members. Below follow an example of how to do this.

 

members_roles

Rate

Share

Share

Rate