Procedure documentationUser Data Locate this document in the navigation structure

 

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.

  • 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 Note

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

End of the note.

Procedure

  1. In the Database Assistant, choose   Edit   Display/Change Integration Data   (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 user 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.

    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   Connection   Save  .

Result

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

End of the caution.

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