HANA sql syntax analytic privilege

[Former Member]

Hello

Could you please advise me what is the correct SQL syntax for granting of analytic privilege to user or role?

I was not able to found this anywhere.

Thanks

[former_member182967 · Accepted solution]

Hi Michal,

Refer to » SAP HANA Analytic Privilege -> Assign Analytic Privilege to a User.

Regards,

Ning

[Former Member · Accepted solution]

Hi Ning

I am aware of that post but it is describing only manual assignment via studio, which is not eligible in our case - many privileges in several databases.

I meant a granting via SQL, something like GRANT <analytic_privilege_name> TO <role_name> but i can't find a correct syntax for analytic privilege.

Regards

[former_member202243 · Accepted solution]

Hi Michal,

The doc you should refer to is HANA security guide, section 'Stored Procedures Used to Grant/Revoke Privileges on Activated Repository Objects'. Specifically:

CALL GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE ('<analytic_privilege>','<user>'/'<role>');

CALL REVOKE_ACTIVATED_ANALYTICAL_PRIVILEGE ('<analytic_privilege>','<user>'/'<role>');

Kind regards,

Wen