Symptom
When trying to grant access to an SAP HDI Container's Schema via [SQL] below, it failed with the following error.
[SQL]
set schema "TESTPRIVILEGE_HDI_TESTMODULE_1#DI";
CREATE LOCAL TEMPORARY COLUMN TABLE #PRIVILEGES LIKE _SYS_DI.TT_SCHEMA_PRIVILEGES;
INSERT INTO #PRIVILEGES ( PRIVILEGE_NAME, PRINCIPAL_SCHEMA_NAME, PRINCIPAL_NAME ) VALUES ( 'SELECT', '', 'COACH1' );
CALL TESTPRIVILEGE_HDI_TESTMODULE_1#DI.GRANT_CONTAINER_SCHEMA_PRIVILEGES( #PRIVILEGES, _SYS_DI.T_NO_PARAMETERS, ?, ?, ?);
DROP TABLE #PRIVILEGES;
When checking the error details (CALL GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS('C07F2AC457007C4792EB9F5591B33FBA', ?)), it shows that the current user does not have EXECUTE privilege on procedure GRANT_CONTAINER_SCHEMA_PRIVILEGES.
C07F2AC457007C4792EB9F5591B33FBA 54:19.1 246885 TESTPRIVILEGE_HDI_TESTMODULE_1_BMZRPQKFL7P4NFHO3V931X5AC_RT TESTPRIVILEGE_HDI_TESTMODULE_1_BMZRPQKFL7P4NFHO3V931X5AC_RT EXECUTE FALSE FALSE TESTPRIVILEGE_HDI_TESTMODULE_1#DI GRANT_CONTAINER_SCHEMA_PRIVILEGES PROCEDURE/FUNCTION
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
SAP HANA, platform edition 2.0 or higher
Product
Keywords
HANA, HDI, dberror) [258], insufficient privilege: Detailed info for this error can be found with guid, GRANT_CONTAINER_SCHEMA_PRIVILEGES, Open SQL Console (Admin) , KBA , HAN-DB-DI , SAP HANA DI (HDI): diserver, HDI plugins& client libs , Problem
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.