EMS logo


SQL Manager for Oracle

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

Documentation en ligne

Managing roles

The Roles tab allows you to define which users/roles may obtain roles and define whether a role should be assigned to the selected user/role by default.


Select a user or role from the Grantee list available within the Navigation bar, then select a role to be allocated to the current user/role and right-click the corresponding cell of the Granted column. The context menu of a cell contains possible permissions that can be granted:

  • Grant
  • Grant with Grant Option
  • Revoke (removes a previously allocated role)
  • Grant All
  • Revoke All


To set the role as default for the selected user/role, double-click the corresponding cell of the Default Role column.


Grant Manager - Managing Roles


See also:

Using Navigation bar and context menu

Managing database-specific privileges

Managing column permissions

Filtering objects in list

Managing system privileges