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 view membership for database roles, you must create a connection to a database that supports roles in the Data Source Explorer.

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.
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