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.
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
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
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
In session mode in Database Manager CLI, you do not have to mask special characters.
More information: DBM Operators
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
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"
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
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
More information: Database Users