Skip to Content
0
Former Member
Sep 10, 2014 at 09:56 AM

Auditing DB activity based specific pre-fixed user .

19 Views

Hi Team,

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 .

Thanks,

Razal