Show TOC

Centralized/Decentralized AuthorizationLocate this document in the navigation structure

Use

The storage of user data for the Database Manager operator (DBM operator) can be either centralized or decentralized.

Note

We recommend that you use central authorization of the user data. As of SAP MaxDB version 7.9, only central authorization is possible.

Central Authorization

The user data for the DBM operator is stored in SAP table DBCONUSR. When the DBM operator is called, this data is used for its authorization.

Decentralized Authorization

User data for the DBM operator is stored in the SAP table DBCONUSR; however, when the DBM operator is called, this data is not used for its authorization.

The XUSER concept is used for the authorization of the DBM operator. You must therefore store the user data on every application server in the XUSER file. You can use, for example, the following Database Manager CLI command to store the DBM operator user data in the user key (user_key) DEFAULT).

dbmcli -ux <default_user_name>,<default_user_password> -us <dbm_operator>,<password> -d <database_name> -n <database_computer>

Procedure

To set centralized or decentralized authorization, follow the procedure described in User Data (SAP MaxDB/SAP liveCache Technology).

More Information

Database Manager CLI, -us: Creating or Changing XUSER Entries

Utilities, XUSER