SAP Knowledge Base Article - Preview

3038175 - Failed to grant access to an SAP HDI Container's Schema due to error: (dberror) [258]: insufficient privilege

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

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

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.