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 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.


Grant Manager - Managing system privileges


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


See also:

Using Navigation bar and context menu

Managing database-specific privileges

Managing column permissions

Filtering objects in list

Managing roles