Show TOC

User DataLocate this document in the navigation structure

Context

By using the transaction Display/Change Integration Data, you can, among other things, specify or change user data for the DBM operator and for the standard database user.

To allow communication between various SAP systems, the standard database user and the DBM operator must be known, as the SAP system differentiates between two types of communication:

  • You must specify the DBM operator and password if you want to connect to the DBM server for database administration purposes. The storage of the DBM operator data in the SAP system can be either centralized or decentralized (Central/Decentral Authorization). SAP recommends that you store user data centrally. As of SAP MaxDB version 7.9, only central authorization is possible.

  • You must specify the standard database user and password if you want to create an SQL connection to the database of another SAP system.

When an SAP system is installed, the DBM operator and the standard database user are stored in the system. This means that additional action is not necessary.

You must, however, check that the user data exists before starting the relevant SAP system, and correct or extend the data, if required. You can create and change the names and the passwords for the DBM operator and the standard database user using the transaction Display/Change Integration Data.

Note

For SAP liveCache technology, the liveCache-specific user menu User Data is available.

Procedure

  1. In the Database Assistant, choose Start of the navigation path Edit Next navigation step Display/Change Integration Data End of the navigation path (transaction DB11).
  2. Enter the name of the database connection.
  3. To be able to change integration information, you must be in change mode. Switch to this mode, if necessary.
  4. Check the information about the database connection (Database Name and Database Server) for completeness and accuracy.
  5. Choose User Data.
  6. Configure the DBM operator and the standard database user.

    DBM Operator:

    
If the database connection already exists, the operator name selected during the installation is displayed. You can change this. Enter and confirm your chosen password. If you want to use central authorization for the user, select Central Authorization. As of SAP MaxDB version 7.9, only central authorization is possible.

    Standard Database User:

    
If the database connection already exists, the operator name selected during the installation is displayed. You can change this. Enter and confirm your chosen password.

  7. Choose Start of the navigation path Connection Next navigation step Save End of the navigation path.

Results

The names and passwords are converted to upper-case letters and encrypted by the SAP system.

The user data for the DBM operator is stored in the DBCONUSR table in the SAP system. The user data for the standard database user is stored in SAP table DBCON. If you make changes, the corresponding entries in the table DBCONUSR or DBCON of the SAP system are updated.

Caution

If the user data in the SAP system does not match the user data in the database, you must manually change the user data on the database, since saving the user data in the SAP system does not update the database data.

  • You can change the DBM operator using any client of the Database Manager (DBMCLI, DBMRFC) (more information: Database Administration, DBM Operators).

  • You can change the standard database user on the database using a query tool of your choice (such as Database Studio or SQLCLI) with a corresponding SQL statement (more information: Database Administration, Database Users).

If you have selected decentral authorization, you must also store the user data on every application server in the XUSER file. To do so, follow the procedure described in Central/Decentral Authorization.

The change to the user data in the database is recorded in the SysLog of your SAP system (transaction SM21).