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