Symptom
You are failed to run select query for following tables in _SYS_DI schema.
"_SYS_DI"."CONTAINERS_"
"_SYS_DI"."CONTAINER_GROUPS_"
"_SYS_DI"."CONTAINER_SCHEMAS_"
"_SYS_DI"."CONTAINER_VERSIONS_"
You tried to grant select privilege with following SQLs.
CREATE LOCAL TEMPORARY COLUMN TABLE #PRIVILEGES LIKE _SYS_DI.TT_API_PRIVILEGES;
INSERT INTO #PRIVILEGES (PRINCIPAL_NAME, PRIVILEGE_NAME, OBJECT_NAME) VALUES('<USER>', 'SELECT', 'CONTAINERS_');
INSERT INTO #PRIVILEGES (PRINCIPAL_NAME, PRIVILEGE_NAME, OBJECT_NAME) VALUES('<USER>', 'SELECT', 'CONTAINERS_');
CALL _SYS_DI.GRANT_CONTAINER_GROUP_API_PRIVILEGES('_SYS_DI', #PRIVILEGES, _SYS_DI.T_NO_PARAMETERS, ?, ?, ?);
DROP TABLE #PRIVILEGES;
However, you got following ERROR:
Granting privileges on "_SYS_DI"."CONTAINERS_" is not permitted.
Read more...
Environment
HANA
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
KBA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-DB-DI , SAP HANA DI (HDI): diserver, HDI plugins& client libs , 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.