Background documentationConventions for User Names and Passwords Locate this document in the navigation structure

 

The following general restrictions apply to user names and passwords:

  • User names must not have more than 18 characters.

  • Passwords must not have more than 9 characters.

In addition, the specific restrictions apply to the different user types.

Database System Administrator

The rules for name and password of the database system administrator are the same as for DBM operators (see below).

As user name, you must not choose SYSDBA. SYSDBA is a reserved SQL keyword.

More information: Database System Administrator

DBM Operators

User name and password are automatically converted into upper-case letters by the database system.

The following characters are permitted:

  • First character:

    A...Z, a...z, $, #, @

  • Other characters:

    A...Z, a...z, $, #, @, 0...9, _

Language-specific characters, such as the German ä umlaut, are not allowed.

When entering user names and passwords on the command line, you may have to mask special characters with an escape character. For more information, see the documentation for your shell.

Example Example

In a Linux bash shell, user OLEG with password M$NDAY logs on to the DEMODB database using Database Manager CLI:

dbmcli -d DEMODB –u OLEG,M\$NDAY

End of the example.

In session mode in Database Manager CLI, you do not have to mask special characters.

More information: DBM Operators

Database Users

User names and passwords can have any character that is described in the following sections of the SQL Reference Manual: User Name (user_name), Password (password).

User name and password are automatically converted into upper-case letters by the database system. If the user name or the password contains lower-case letters and you do not want the database system to convert them into upper-case letters, put the whole user name or the whole password in quotation marks.

Example Example

To log on to a database as user MONA with password Red using Database Studio, enter the following information in the logon dialog box in Database Studio:

MONA

"Red"

End of the example.

When entering user names and passwords on the command line, you may have to mask special characters, such as $ or the quotation mark, with an escape character. For more information, see the documentation for your shell.

Example Example

In a Linux bash shell, user MONA with password R$D logs on to the DEMODB database using SQLCLI:

sqlcli -d DEMODB -u MONA,R\$D

End of the example.

More information: Database Users