Online Documentation for SQL Manager for Oracle

Creating/editing role

Use the Role tab of Role Editor to create/edit a role and specify its properties.



Specify the name of the new role, or view the name of the role being edited.


Role Editor - Editing role definition


Authentication method


RadioButton Password authentication

Indicates that a password must be specified to log on to the database. Set the password and confirm it using the corresponding boxes.


RadioButton Operating system authentication

The role must be authenticated by an external service - operating system. In this case, Oracle relies on authentication by the operating system to ensure that a specific external user has access to a specific database role.


RadioButton Global authentication

The role must be authorized by the enterprise directory service (Oracle Internet Directory).


RadioButton Not identified

Indicates that this role is authorized by the database and that no password is required to identify the role.


RadioButton Application

Creates an application role, which is a role that can be enabled only by applications using an authorized package. In this case you need to specify the Schema and Package used for authentication.


To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.