Conventions for User Names and Passwords

You are free to choose user names and passwords. The following restrictions do apply, however:

?     User names may not have more than 18 characters.

?     Passwords may not have more than 9 characters.

In addition, the following restrictions apply to the different MaxDB users.

Database System Administrator

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

Do not choose SYSDBA as the user name. SYSDBA is a reserved SQL keyword.

See Database System Administrator (SYSDBA User).

Database Manager Operator (DBM Operator)

The user name and password are automatically converted into uppercase 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 д, are not allowed.

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

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

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

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

See Database Manager Operator (DBM Operator).

Database User

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).

The user name and password are automatically converted into uppercase letters by the database system. If the user name or the password contains lowercase letters and you do not want the database system to convert them into uppercase letters, you have to set the whole user name or the whole password in quotation marks.

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

MONA

"Red"

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

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

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

See Database Users.

See also:

Users, Authentication and Authorizations