SAP HANA audit policy syntax

[Former Member]

Hi Folks,

I have a question, i am trying to enable the change authorisation and want to exempt some users from the same.

SQL query i was trying to generate is as below

drop AUDIT POLICY Change_Authorization;

create AUDIT POLICY Change_Authorization

AUDITING ALL

GRANT PRIVILEGE, REVOKE PRIVILEGE,

GRANT ROLE, REVOKE ROLE

LEVEL WARNING;

ACTIONS EXCEPT for SAPSR3

ALTER AUDIT POLICY Change_Authorization ENABLE;

But somehow it doesnt work. Has anyone tried using the except syntax rather than going through studio?

<actions_for_user> ::= ACTIONS [EXCEPT] FOR <user_name>[{, <user_name>}...]

[Former Member · Accepted solution]

p51770,

Try this:

CREATE AUDIT POLICY Change_Authorization

AUDITING ALL

GRANT PRIVILEGE, REVOKE PRIVILEGE,

GRANT ROLE, REVOKE ROLE

EXCEPT FOR SAPSR3

LEVEL WARNING;

Good luck,

Robert