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 256 characters.
The maximum password length has been increased starting with SAP MaxDB software version 7.8.
SAP MaxDB clients with software version < 7.8 can only handle users with a maximum password length of 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
User name and password are automatically converted into upper-case letters by the database system.
The following characters are permitted:
A...Z, a...z, $, #, @
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.
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 \$ N D AY
In session mode in Database Manager CLI, you do not have to mask special characters.
More information: DBM Operators
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.
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:
" 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.
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