cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

execute GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE -> insufficient privilege

marke_
Explorer
0 Likes
1,012

Hi,

I want to grant authorize user to grant several analytics privileges (Z*).

Users have:
execute on GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE
select on <schema>

_SYS_REPO:
select on <schema> with grant option

But user still getting error 'insufficient privilege' when calling GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE.

GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS says:

GUID;CREATE_TIME;CONNECTION_ID;SESSION_USER_NAME;CHECKED_USER_NAME;PRIVILEGE;IS_MISSING_ANALYTIC_PRIVILEGE;IS_MISSING_GRANT_OPTION;DATABASE_NAME;SCHEMA_NAME;OBJECT_NAME;OBJECT_TYPE
1E25A27025598849B330CC8D6DD77946;21.12.2020 17:28:14.978;353.692;<user>;_SYS_REPO;;FALSE;TRUE;;;bw2hana/<schema>__SYS_BIC_Z....;ANALYTICALPRIVILEGE

Is the problem "IS_MISSING_GRANT_OPTION"? But what I have to do?

Thank you.

Accepted Solutions (0)

Answers (1)

Answers (1)

santoluc
Explorer
0 Likes

HAve you find a solution?