Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Auditing DB activity based specific pre-fixed user .

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

Former Member
Not what you were looking for? View more on this topic or Ask a question