SAP Knowledge Base Article - Public

3295677 - How to create new user on Hana Data Lake - SAP IQ

Symptom

"User and Role Management" in SAP HANA COCKPIT can't create new users.

Environment

  • HANA Clout Hana Data Lake
  • SAP IQ

Cause

  • SAP HANA COCKPIT only shows the list of users and roles.
    No facility is provided to edit these.

Resolution

  • A login user is created using the “CREATE USER” statement.
    Execute SQL statements from the SQL Console.
  • See the SAP IQ Reference Guide for details on the "CREATE USER" statement.
  • PUBLIC and SYS_DL_CUSTOMER_ROLE are granted by default when creating a new user in HDL.
    If you want to assign other ROLE, use "GRANT ROLE" statement.

ex:

CREATE USER ADMIN02 IDENTIFIED BY xxxxxxx;
GRANT ROLE SYS_DL_CUSTOMER_ADMIN_ROLE to ADMIN02 WITH ADMIN OPTION

See Also

Keywords

HDL, HANA, Hana Data Lake, IQ, user, role, create , KBA , HAN-CLS-HC-HDL , HANA Cloud HANA Data Lake , BC-SYB-IQ , Sybase IQ , Problem

Product

SAP Analytics Cloud 1.0