EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

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

 


See also:

Using Navigation bar and context menu

Managing column permissions

Filtering objects in list

Managing system privileges

Managing roles