Symptom
You want to refresh a virtual table, but 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"
Read more...
Environment
- SAP HANA DB PLATFORM 1.0
- SAP HANA DB PLATFORM 2.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
Refresh a Virtual Table, Cannot grant privilege , KBA , HAN-DB-DI , SAP HANA DI (HDI): diserver, HDI plugins& client libs , HAN-DB-SEC , SAP HANA Security & User Management , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.