SAP Knowledge Base Article - Preview

3125732 - Cannot assign missing ALTER object privilege to refresh virtual table for HDI container

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.