Show TOC

Removing Inconsistent Mappings in DBMS User ManagementLocate this document in the navigation structure


You have configured DBMS user management.


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.


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

    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.

  4. Choose Execute.

    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.

  5. Decide how to handle any inconsistent users.



    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.

  6. Choose Back F3.
  7. Enter data as required.

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

  8. Choose Execute.