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

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

• HANA Clout Hana Data Lake
• SAP IQ

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

• 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

• SAP IQ SQL Reference

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