3658943 - How to grant multiple object privileges for one HDI container to different DB users

You need to grant access to an SAP HDI Container's schema to another DB user.

You have followed the command in the guide:

Grant Access to an SAP HDI Container's Schema

CREATE LOCAL TEMPORARY COLUMN TABLE #PRIVILEGES LIKE _SYS_DI.TT_SCHEMA_PRIVILEGES; 
INSERT INTO #PRIVILEGES ( PRIVILEGE_NAME, PRINCIPAL_SCHEMA_NAME, PRINCIPAL_NAME ) VALUES ( 'SELECT', '', '<NEW_CONTAINER_CONSUMER>' );
CALL <container_name>#DI.GRANT_CONTAINER_SCHEMA_PRIVILEGES( #PRIVILEGES, _SYS_DI.T_NO_PARAMETERS, ?, ?, ?);
DROP TABLE #PRIVILEGES;


Now you want to know if you can grant multiple object privileges like Select, Delete, Update at the same time. Or grant one object privilege to different users.

• SAP HANA Cloud
• SAP HANA Platform Edition 2.0

 HDI container, schema privileges, grant access, database explorer, HDI user restrictions. , KBA , HAN-DB-DI , SAP HANA DI (HDI): diserver, HDI plugins& client libs , HAN-CLS-HC , HANA Cloud Services HANA Cloud , HAN-DB-SEC , SAP HANA Security & User Management , Problem