Online Documentation for SQL Administrator for SQL Server

Setting permissions


The Permissions section of the Edit Database window allows you to set permissions to users.

 

Database Editor - Setting permissions

 

 

Principal name

This column contains the name of the database-level principals (users or roles).

Note: If you double-click the user / role name then the User Editor / Role Editor appears.

 

To change a permission to modify in the table select this permission from the drop-down list situated in the Permissions tab of the navigation bar.

 

Right-click a cell within the permission column to grant a permission to the principal. The context menu of a cell allows you to:

  • grant a permission to the principal;
  • grant a permission (with Grant Option) to the principal;
  • deny a permission to the principal;
  • revoke a previously granted or denied permission;
  • grant all permissions to the principal;
  • grant all permissions (with Grant Option) to the principal;
  • deny all permissions to the principal;
  • revoke all previously granted or denied permissions.

Note: Permissions can be granted to a principal by double-clicking a corresponding cell in of the permission column.

 

Also you can view effective permissions granted to the principal using the context menu.

 

Database Editor - Setting effective permissions

 

 

The opened window displays information about all 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.