Online Documentation for SQL Manager for Oracle

Managing database-specific privileges

The Database-specific privileges area of the Objects Grants tab allows you to define privileges on database objects and grant privileges to a user or role.

To edit the privileges of a user/role on an object of a database, select the database using the Database pane of the Navigation bar, then select a user or role from the Grantee list available within the Navigation bar. Then select the type of objects to be displayed in the main working window using the drop-down list at the top.

The Object Name column contains the list of objects of the selected type; each subsequent column corresponds to the permission which can be granted on the selected object: Alter, Delete, Execute, Debug, Flashback, Index, Insert, On Commit Refresh, Query Rewrite, Read, References, Select, Under, Update, Write.

The list of the objects can be configured in several ways: you can specify that only granted objects are displayed in the grid, or define a schema and object name to filter the objects by that name.

Right-click a cell to grant a specific permission on a certain object. To grant a permission on an object, you should find the object in the Object Name list and the column with the corresponding permission. The context menu of a cell contains possible permissions that can be granted:

Grant

Grant with GRANT Option

Revoke (removes a previously granted permission)

Grant All

Revoke All