Working with Privileges

Security Manager allows granting and revoking system and object privileges easily. This topic describes how to work with system privileges and privileges on database objects.

Granting and Revoking System Privileges

  1. Open Security Manager.
  2. Select a user account or role in the left part of the Security Manager.
  3. Switch to the System tab.
  4. Select checkboxes opposite to the required privileges to grant them, and clear the check boxes to revoke already granted privileges.
  5. Click the Save button on the Security Manager toolbar to apply changes.

Granting and Revoking Privileges on Database Objects

Privileges on database objects can be granted on the Object tab of the Security Manager.

Granting privileges

To give a user or role some privileges on a database object, perform the following actions.

  1. Open the Security Manager by selecting Security Manager on the Database menu or selecting Edit Privileges on the shortcut menu of database object node in Database Explorer.
  2. Select a user account or role in the left part of the Security Manager and switch to the Object tab.
  3. Select a database object to grant privileges on in the Objects tree. After selecting an object you will see the list of available privileges.
  4. Assign privileges to a user (account) or role by checking them in the available privileges list.
  5. Click the Save button on the Security Manager toolbar.

Revoking privileges

The grid at the bottom of the Security Manager Object tab contains the current privileges of the user (account) or role.

You can revoke selected privilege by:

  1. Double-clicking it
  2. Clicking the Revoke Selected Privilege on their shortcut menu
  3. Pressing the CTRL+DELETE keys
  4. Clicking the button near the list

To revoke all assigned privileges, select Revoke All Privileges from their shortcut menu or click the button near the list.

Available privileges

Available privileges for different database objects are listed at the table below:

Database objects Privileges
Databases Select, Insert, Update, Delete, Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create View, Drop, Event, Execute, Grant Option, Index, Lock Tables, References, Show View, Trigger
Tables Select, Insert, Update, Delete, Create, Drop, Grant Option, References, Index, Alter, Create View, Show View, Trigger
Columns Select, Insert, Update, References
Stored procedures and functions Alter Routine, Execute, Grant Option