Imperva Cyber Community

Expand all | Collapse all

DB Monitoring and Audit on specific Table Group

  • 1.  DB Monitoring and Audit on specific Table Group

    Posted 9 days ago
      |   view attached
    We had added several tables under table group, however it was not captured on the audit policies. Can someone explain why the audit policy not working on this case?

    We did some testing over the MSSQL DB Server by using the query below.

    Example:
    select top 100 * from
    abc.dbo.qwer;

    For the table group from global object, we only define dbo.qwer

    From the example above, can we monitoring everything of *.dbo.qwer?


    #DatabaseActivityMonitoring

    ------------------------------
    kahhou looi
    ------------------------------


  • 2.  RE: DB Monitoring and Audit on specific Table Group

    Imperva Employee
    Posted 8 days ago
    In the example given you have included the schema (owner) with the table name into the table group list.
    just add the table and columns to table groups and ensure the table group is associated to the site tree service / application. 
    The database and schema mapping can be done via the application tab from the service in the site tree.

    Regards

    ------------------------------
    Trevor Jackson
    ------------------------------



  • 3.  RE: DB Monitoring and Audit on specific Table Group

    Imperva Employee
    Posted 8 days ago
    Hello Kahhou
    I hope the information you received from Trevor helped address your issue. Please reply if it did not and we can help you get the right response.
    Kedar

    ------------------------------
    Kedar Dhuru
    ------------------------------



  • 4.  RE: DB Monitoring and Audit on specific Table Group

    Imperva Employee
    Posted 5 days ago
    Hi,

    please note that, in addition to referencing your TGs in Policies, Table Groups will have to be attached to your Application they relate to.



    ------------------------------
    Pal Balint
    ------------------------------