Removing Inconsistent Mappings in DBMS User Management

Prerequisites

You have configured DBMS user management.

Context

When you synchronize database management system (DBMS) user management with SAP NetWeaver Application Server (SAP NetWeaver AS) user management, you must periodically check that the users SAP NetWeaver AS expects are still available.

SAP NetWeaver AS provides the RSUSR_DBMS_USERS_CHECK report to check for all users that have a mapping to a DBMS user if the DBMS user exists. Use this report to either remove the mapping for missing DBMS users or create DBMS users.

Procedure

Start report RSUSR_DBMS_USERS_CHECK with ABAP: Program Execution (transaction SA38).
Choose Select inconsistent users.
Enter a range of users.

Note
To reduce the runtime of the report for systems with large numbers of users, you can specify individual user names or ranges to search for inconsistent data.
Choose .

SAP NetWeaver Application Server ABAP returns the list of users that are inconsistent, if any. These users are SAP NetWeaver Application Server ABAP users for which a mapping is saved, but the user saved in the mapping does not exist in the DBMS.

Decide how to handle any inconsistent users.

Solution	Implication
Remove the mapping	The user for SAP NetWeaver Application Server ABAP no longer has a matching DBMS user. Any scenarios dependent on having users in both systems no longer work.
Create the DBMS user	The user for SAP NetWeaver Application Server ABAP has a matching DBMS user. The user has an initial password. You must inform the owner of the users about the new DBMS user and the initial password.

Choose .
Enter data as required.

Enter users or ranges of users and select the appropriate action.
Choose .