How to assign an Analytic privilge to user using SQL?

[former_member42822]

Hi,

How do i assign an Analytic Privielge which is inside a package to a User using sql?

The sql below doesnt work if the Analytic Privilege is inside a package.

call GRANT_ACTIVATED_ANALYTIC_PRIVILEGE('AP',TESTUSER)

regards,

Vinoth

[rindia · Accepted solution]

Hi Vinoth,

If you created the analytic privilege dynamically using SQL then only use SQL like this

GRANT STRUCTURED PRIVILEGE "srk/STRUCT_PRIV_AN_DYNAMIC" TO USER1;

For more details, please refer to my document http://scn.sap.com/docs/DOC-41261

Regards

Raj

[former_member42822 · Accepted solution]

Thank you Raj.

It was very informative. This is exactly what i was looking for.

Regards,

Vinoth

[rindia · Accepted solution]

Good to know that you got what you want

[rindia]

Hi Vinoth,

The actual way to assign privilege to user is by using Security folder in HANA studio and open the user whom you want to give privilege as shown below.

         

Analytic privilege will be assigned like this:

       

Is there any reason you does not want to use this option?

Regards

Raj