SAP Knowledge Base Article - Preview

3332645 - Failed to run select query for a few tables in _SYS_DI schema

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.