To simplify user management of the database management system (DBMS), you can update attributes such as the Kerberos name, e-mail, and validity period of DBMS users from SAP NetWeaver Application Server for ABAP (SAP NetWeaver AS 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.
-
For Kerberos name, you have maintained an SNC name for the users.
This report derives the external ID from the SNC name.
- For e-mail address, you have maintained e-mail addresses for the users.
Procedure
- In ABAP: Program Execution (transaction SA38), start report RSUSR_DBMS_USERS.
- 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.
- Choose the Update specific attributes function.
| Option |
Description |
| Kerberos Name (Derived from SNC Name) |
Derives the external ID from the SNC name for selected users in SAP HANA.
To enable the Keberos authentication method, use the Enable authentication methods function. |
| E-Mail |
Updates the current e-mail attribute for selected users in SAP HANA. |
| Validity Period |
Updates the current validity period attributes for selected users in SAP HANA. |
| Force Update |
This report does not overwrite existing entries for these parameters. Set this option to enable this report to overwrite the values in the DBMS. |
- Choose Execute.