Auditing DB activity based specific pre-fixed user .
I am working on HANA auditing topic now ,
- We have a requirement to track user activities only if they are name with a prefix .
For Example LOCAL_ABC and LOCAL_A1F both of this user should be captured in the policy .
- Something similar like below
CREATE USER LOCAL_FRED PASSWORD Initial_1;
CREATE USER LOCAL_FREDY PASSWORD Initial_1;
CREATE SCHEMA MY_SCHEMA OWNED BY system;
CREATE TABLE MY_SCHEMA.MY_TABLE (first_col int);
GRANT INSERT ON MY_SCHEMA.MY_TABLE to LOCAL_JOHN;
GRANT INSERT ON MY_SCHEMA.MY_TABLE to LOCAL_JOSE;
CREATE AUDIT POLICY OBJECT_AUDIT AUDITING SUCCESSFUL INSERT ON MY_SCHEMA.MY_TABLE FOR LOCAL* LEVEL INFO
Is there a possibility to do this , Like tracking a group of users .