Configuring DBMS User Management for SAP HANA

You can customize a client of SAP NetWeaver Application Server (SAP NetWeaver AS) to manage database management system (DBMS) users on SAP HANA.

Prerequisites

You have created a database user in SAP HANA with the following attributes:

You have assigned the database user privileges appropriate to the functions you want to be able to manage from SAP NetWeaver AS for ABAP.

Privileges for the Database User
Privilege	Privilege Type	Description
USER ADMIN	System	Enables you to maintain users in the DBMS.
ROLE ADMIN	System	Enables you to grant and revoke roles. Note This privilege also grants a user in SAP HANA the authorizations to create and delete roles.
CATALOG READ	System	Enables you to display role assignments granted by users other than the user created for the database connection, for example the system user _SYS_REPO.
EXECUTE on the procedure GRANT_ACTIVATED_ROLE	SQL	Enables you to grant roles created in the SAP HANA repository to DBMS users.
EXECUTE on the procedure REVOKE_ACTIVATED_ROLE	SQL	Enables you to revoke roles created in the SAP HANA repository to DBMS users.

The database user must log on with user name and password.
The database user has a productive password.

To ensure the password is productive, log on with the user and password with an application such as SAP HANA developer studio.

Add a database connection in table DBCON with Change View "Description of Database Connections": Overview (transaction DBCO) for the database user and database type HDB.
Enter the name of the database connection and the client in the USR_DBMS_SYSTEM view with Maintain Table View (transaction SM30).