on ‎2020 Dec 22 9:10 AM
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.
Request clarification before answering.
HAve you find a solution?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 11 | |
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.