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.

 

Grant Manager - Viewing effective permissions - Tree

 

 

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.

 

Grant Manager - Viewing effective permissions - Current