Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    73

    Question Unanswered: SQL Server Compliance Tool For Audits

    Our Company is looking for Auditing tool to meet the compliance requirements,
    i am looking for something which has following features

    1. It logs in all the changes even DBA should not be able to change the stuff
    Which is logged by audit system

    2. Performance of SQL should not be affected.

    3. Auditing system should log, which record changed when in which table which database

    4. I am able to pull up monthly reports , who changed which records and at what day,date etc

    5. I should be able to filter audited data (Filter by user)

    Please help, please suggest any tool

    we are running SQL Server 2008 Standard
    we have 30 databases in production, with size varying from 8GB to 40 GB

  2. #2
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    I suggest you either upgrade to Enteprise Edition and use the built-in CDC (Change Data Capture) or purchase a third-party CDC solution such as Attunity.

    You will then need someone to configure and monitor this if you don't want your DBA to have responsibility for it.

  3. #3
    Join Date
    Aug 2009
    Posts
    73

    Question

    CDC has everything we need except capturing the Usernames , i also tried creating a column(on cdc_db0_table_ct) with default value of System_User but it always captures SA,
    any suggestions??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •