Online Documentation for SQL Manager for Oracle
Managing database-specific privileges
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.
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 with GRANT Option
Revoke (removes a previously granted permission)