Use the Roles Membership view to see which authorization
IDs (for example, users or groups) are granted membership in a particular
role.
Before you begin
Before you view membership for database roles, you must create
a connection to a database that supports roles in the Data Source
Explorer.
Procedure
To view membership for database roles:
- Right-click a role in the Data Source Explorer (or
the Object List for products that include this view).
- Select View Membership. If
the View Membership menu is not available,
this action is not available for your database server.
Results
The complete set of users and groups that are members of the
selected role, directly or indirectly, are displayed in the Roles
Membership window.