Maintaining Authentication Methods for Many DBMS Users

To simplify user management of the database management system (DBMS), you can maintain the authentication method of DBMS users from SAP NetWeaver Application Server for ABAP. Use report RSUSR_DBMS_USERS.

Prerequisites

  • You have customized SAP NetWeaver AS for ABAP to use DBMS user management.

  • You have logged on with a user, who has the required authorizations.

    This report checks the authorization object S_USER_GRP for the activity 02 for editing and 03 for display.

Procedure

  1. In ABAP: Program Execution (transaction SA38), start report RSUSR_DBMS_USERS.
  2. In the User Selection section, enter user selection criteria.

    Test your selection criteria by choosing the function Display users and choosing Execute. Then go back and adjust your selection criteria as required.

  3. Choose the Enable authentication methods function.
  4. Enter the required data.
    • To enable an authentication method for the selected DBMS users, set the corresponding checkbox and make sure the Change checkbox is selected.
    • To disable an authentication method for the selected DBMS users, clear the corresponding checkbox and make sure the Change checkbox is selected.
  5. Choose Execute.

Next Steps

If you enabled the Kerberos authentication method, you must set the external ID. Choose the function Update specific attributes to derive the external ID from the users' SNC name.
Related Information