Removing Inconsistent Mappings in DBMS User Management

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

Prerequisites

You have configured DBMS user management.

Context

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

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

    SAP NetWeaver AS for ABAP returns the list of users that are inconsistent, if any. These users are SAP NetWeaver AS for ABAP users for which a mapping is saved, but the user saved in the mapping doesn’t exist in the DBMS.

  5. Decide how to handle any inconsistent users.

    Solution

    Implication

    Remove the mapping

    The user for SAP NetWeaver AS for 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 AS for ABAP has a matching DBMS user. The user has an initial password. Inform owners 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.