It can be difficult to view the exact permissions within SQL Server granted to a specific login, especially when that login is a member of multiple groups and roles. To help administrators understand exactly what permissions are assigned to a particular login, RockSolid provides the Effective Permissions function.
Viewing Effective Permissions
To view effective permissions:
- Navigate to the SQL Server login that you wish to view permissions for. This may be a direct SQL Server login, or an indirect SQL Server login via Windows Group membership.
- Click on the "Effective Permissions" tab.
This screen shows the detail of all objects and permissions granted to the login.