execute GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE -> insufficient privilege

marke_ — Tue, 22 Dec 2020 09:10:25 GMT

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.

Re: execute GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE -> insuf...

santoluc — Wed, 25 Jun 2025 09:26:30 GMT

HAve you find a solution?

Question Re: execute GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE -> insuf... in Technology Q&A

execute GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE -> insufficient privilege

Re: execute GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE -> insuf...