EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

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

 

 


See also:

Using Navigation bar, Toolbar and context menu

Setting object permissions

Managing column permissions

Filtering objects in list

Setting database permissions