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.


Grant Manager - Managing database-specific privileges


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:

iconGrantManager_Grant Grant

iconGrantManager_GrantWithGrantOption Grant with GRANT Option

iconGrantManager_Revoke Revoke (removes a previously granted permission)

iconGrantManager_GrantAll Grant All

iconGrantManager_RevokeAll Revoke All