Show TOC

Configuring DBMS User Management for SAP HANALocate this document in the navigation structure

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 Application Server ABAP.

    Table 1: 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.

Context

Note

Password synchronization and password locks are not supported.

This customizing is client-specific.

Recommendation

Only customize one ABAP client. The same user ID on different ABAP clients can represent different users with different authorizations. It is not good practice to map them to the same DBMS user.

Procedure

  1. 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.
  2. Enter the name of the database connection and the client in the USR_DBMS_SYSTEM view with Maintain Table View (transaction SM30).
Related Information