Online Documentation for SQL Manager for Oracle

Managing system privileges

The System Privileges tab allows you to allocate system privileges to the selected user/role.

To edit the system privileges of a user/role, 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.

Right-click a cell next to the system privilege to grant this privilege to the selected user or role. 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