Online Documentation for SQL Manager for Oracle

Creating/editing user

Use the User tab of User Editor to create/edit a user and specify its properties.



Specifies the name by which the user is identified inside this database. This name can contain only characters from the database character set and comply with the naming rules.


User Editor - Editing user definition



Authentication method


RadioButton Password authentication

Indicates that the user must specify a password to log on to the database.


CheckBox Expire password now

This setting forces the user or the DBA to change the password before the user can log in to the database.


RadioButton Operating system authentication

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


RadioButton Global authentication

The user must be authorized by the enterprise directory service (Oracle Internet Directory). In this case you are to fill all necessary fields below as follows: common name, locality, country, state, organization, unit, X.500 name.


Resource profile

Use the drop-down list to specify the profile you want to assign to the user. The profile limits the amount of database resources the user can use.


CheckBox Lock account now

Use this option to lock the user's account and disable access.


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