Online Documentation for SQL Manager for SQL server
Viewing effective permissions
An effective permission is the one which is:
- granted directly to the principal, and not denied, or
- implied by a higher-level permission held by the principal and not denied, or
- granted to or held by, a role or group of which the principal is a member, and not denied.
The Grants Tree tab of the Effective Permissions dialog displays the entire list of permissions granted to the user and its role on a definite object in the form of a tree. For your convenience the Refresh, Expand/Collapse buttons are available at the bottom of the dialog window.
The Current Effective Permissions tab of the Effective Permissions dialog displays a list of the permissions effectively granted to the specified principal on a definite object.