3125732 - Cannot assign missing XXX object privilege on HDI container, the privilege you want to assign is not in the accepted value list

You want to grant some object privileges on HDI container to your user for certain business purpose, but failed.

For example, for refresh a virtual table scenario, you found it failed due to missing ALTER object privilege according to the GUID string.

ALTER VIRTUAL TABLE ZSCHEMA.VIRTUAL_TABLE REFRESH DEFINITION;

And below steps are followed to grant the access for the HDI container:

set schema ZSCHEMA#DI;
CREATE LOCAL TEMPORARY COLUMN TABLE #PRIVILEGES LIKE _SYS_DI.TT_SCHEMA_PRIVILEGES; 
INSERT INTO #PRIVILEGES ( PRIVILEGE_NAME, PRINCIPAL_SCHEMA_NAME, PRINCIPAL_NAME ) VALUES ( 'ALTER', '', '<YOUR USER>' );
CALL ZSCHEMA#DI.GRANT_CONTAINER_SCHEMA_PRIVILEGES( #PRIVILEGES, _SYS_DI.T_NO_PARAMETERS, ?, ?, ?);
DROP TABLE #PRIVILEGES; 

Error while running the grant procedure:

"ALTER": Cannot grant privilege; accepted values are "CREATE ANY", "CREATE TEMPORARY TABLE", "EXECUTE", "SELECT", "SELECT METADATA", "INSERT", "UPDATE", "DELETE", "DEBUG", "DEBUG MODIFY", "UNMASKED", and "SQLSCRIPT LOGGING"

• SAP HANA DB PLATFORM 1.0
• SAP HANA DB PLATFORM 2.0
• SAP HANA CLOUD 1.0

Refresh a Virtual Table, Cannot grant privilege, ALTER, TRIGGER, HDI container, object privileges, grant, DBADMIN, ROLE ADMIN , KBA , HAN-DB-DI , SAP HANA DI (HDI): diserver, HDI plugins& client libs , HAN-DB-SEC , SAP HANA Security & User Management , HAN-CLS-HC , HANA Cloud Services HANA Cloud , How To