What is the system privilege required to grant "Analytic Privilege" to a user

[former_member182302]

Hi SCN,

I have the user with following privileges:

SYSTEM Privileges: CATALOG READ,CREATE STRUCTURED PRIVILEGE,DATA ADMIN,STRUCTUREDPRIVILEGE ADMIN,USER ADMIN

PACKAGE Privileges: SECURITY

OBJECT Privileges: _SYS_BI,_SYS_BIC and REPOSITORY_TEST

Am able to create a AP, but not able to assign to a user.  Checked different threads and documents, Am able to add with "SYSTEM" user but not with the generic user i have

I can't do tracing as it is disabled in the client system

Am i missing something here? Can someone help me please?

Regards,

Krishna Tangudu

[rindia · Accepted solution]

Hi Krishna,

You must have object privilege EXECUTE on the procedure GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE.

Regards

Raj

[former_member182302 · Accepted solution]

Thank you so much Raj.

I was expecting this kind of privilege under SYSTEM PRIVILEGE.

So other privileges which i mentioned are fine right?

Regards,

Krishna Tangudu

[rindia · Accepted solution]

It seems ok.