To simplify user management of the database management system (DBMS), you can create and
delete role assignments of DBMS users from SAP NetWeaver Application Server
(SAP NetWeaver AS) ABAP. Use report
RSUSR_DBMS_USERS.
Prerequisites
-
You have customized SAP NetWeaver Application Server 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
- 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 . Then go back and adjust your selection criteria as required.
- In the DBMS Role Selection section, select the DBMS
roles you want to assign or remove.
You can select the DBMS roles directly or select the roles assigned to a particular user.
Selecting the roles from a particular user is useful when you want to copy
the role assignments of one user to another.
- Choose the role maintenance operation.
-
To assign the roles you selected, choose Assign DBMS
roles.
-
To remove the role assignments for the roles you selected, choose
Remove DBMS roles.
- Choose .