HOW TO: View Effective Login Permissions

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:

This screen shows the detail of all objects and permissions granted to the login.

Have more questions? Submit a request


Please sign in to leave a comment.