Changing the Passwords of Standard Users 

Use

The following standard users are created during the installation of the MaxDB database system.

MaxDB Standard Users

Name (Default value)	Password (Default value)	Description
DBADMIN DBA (up to version 7.5 inclusive)	SECRET DBA (up to version 7.5 inclusive)	Database System Administrator (SYSDBA user)
DBM	SECRET DBM	Database Manager Operator (DBM operator) with all server authorizations
DBSERVICE	SECRET	Only for version 7.6.10 to 7.6.25: Synchronization user for the Synchronization Manager If you do not use the Synchronization Manager, you can delete this user and all the database objects assigned to it.

As a rule, the following standard users are created during installation in SAP systems.

SAP Standard Users for Databases

Name	Password	Description
SUPERDBA	User-defined, set at the time of installation	Database system administrator (SYSDBA user)
CONTROL	User-defined, set at the time of installation	Database manager operator (DBM operator) with all server authorizations
SAPR3	User-defined, set at the time of installation	In older SAP systems: Database administrator (database user of type DBA)
SAP<SAPSID>	User-defined, set at the time of installation	In newer SAP systems, in particular in MCOD systems (Multiple Components One Database): Database administrator for the SAP system with the ID <SAPSID> (database user of the type DBA)
SAP<SAPSID>DB	User-defined, set at the time of installation	In J2EE systems: Database administrator for the SAP system with the ID <SAPSID> (database user of the type DBA)

These users have comprehensive authorizations for working with the database system MaxDB.

Procedure

To keep unauthorized persons from learning the passwords of standard users, we recommend the following measures:

●     Do not adopt the default passwords.

●     Use secure passwords.

●     Change the passwords regularly.

●     To enable another user to work temporarily with the account of the database system administrator (SYSDBA user), you can temporarily assign a second password to the database system administrator. This way you do not have to reveal the password of the database system administrator.

Changing the Passwords for MaxDB Standard Users

Use the Database Manager database tool, or the CCMS in SAP systems. See

●     Database Manager GUI
Changing the Password of the Database System Administrator
Changing the Password of a Database Manager Operator
Changing the Password of a Database User

●     Database Manager CLI
user_put

●     Database Administration in CCMS: MaxDB, User Data

●     Database Administration in CCMS: SAP liveCache Technology, User Data

For security measures for standard operating system users, see Changing the Passwords of SAP Standard Operating System Users.

Assigning a Temporary Second Password to MaxDB Standard Users

Use the database tool Database Manager. See

●     Database Manager GUI
Changing the DMB Operator Properties of the Database System Administrator
Changing the DBM Operator Properties

●     Database Manager CLI
user_put