Online Documentation for SQL Administrator for SQL Server

Server Permissions

Use this page to manage server permissions.

Toolbar

You can choose to Select Principal or Select Securable by clicking the corresponding buttons on the toolbar. In the first case you are to set Server, Server Role (for SQL Server 2012), Login or Endpoint permissions to the Principal (login or server role (for SQL Server 2012)) selected from the corresponding drop-down list.

If you click Select Securable then you are to select the server Securable Type from the drop-down list: Server permission, Server Role, Login or Endpoint. Then choose the securable name from the Securable drop-down list to set permissions for.

Click the toolbar button if you want to view objects with granted or denied permissions only.

Right-click a cell next to the required permission to grant its execution privilege to the selected principal. The context menu of a cell contains possible permissions that can be granted:

Grant

Grant with Grant Option

Revoke (removes a previously granted permission)

Deny

• Grant All
• Grant All with Grant Option
• Revoke All
• Deny All
• Grant on All Objects / to All Principals
• Grant with Grant Option on All Objects / to All Principals
• Revoke on All Objects / from All Principals
• Deny on All Objects / to All Principals

Hint: You can also assign privileges by double-clicking the respective cell - in this case the grant status is changed in the following order: Grant -> Grant with Grant Option -> Deny -> Revoke.

Use the Print context menu item or the corresponding toolbar button to create and print the report.

When you grant permissions for principals the context menu allows you to:

create a new login

edit the selected login(s)

drop selected login(s)

create a new server role

edit the selected server role(s)

drop selected server role(s)

See also:

Logins

Database users

Database roles

Application Roles

Server Roles

Database Permissions