Viewing membership for database roles

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.
About this task

To view membership for database roles:

  1. Right-click a role in the Data Source Explorer.
  2. 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 view.

Feedback