Show TOC

DBMS User ManagementLocate this document in the navigation structure

Database management system (DBMS) user management enables SAP NetWeaver Application Server (SAP NetWeaver AS) ABAP to manage users and their privileges on the DBMS.

In a typical SAP NetWeaver Application Server ABAP installation, you maintain the users that run applications on SAP NetWeaver Application Server ABAP. In the DBMS, you maintain a few technical users, but you do not need users in the DBMS for most of your SAP NetWeaver Application Server ABAP users. There are use cases that require you to maintain users in the DBMS.

  • SAP Business Warehouse (SAP BW), needs a 1:1 user mapping to map analytic privileges of the database to the virtual analysis authorizations of the SAP BW.

  • Your users run applications that access the database directly. You must assign privileges to the user in the database.

To simplify user management of the DBMS, you can create a connection between the user management of SAP NetWeaver Application Server ABAP and the DBMS. When you create users in SAP NetWeaver Application Server ABAP, the SAP NetWeaver Application Server ABAP creates the users in the DBMS automatically, with the same user ID and password. Setting an administrative lock on an SAP NetWeaver Application Server ABAP user also locks the corresponding DBMS user. You can also add and remove DBMS privileges for the DBMS user as far as this is allowed by the DBMS.

Note

Password synchronization and password locks are not supported.

This customizing is client-specific.

Recommendation

Only customize one ABAP client. The same user ID on different ABAP clients can represent different users with different authorizations. It is not good practice to map them to the same DBMS user.