Home Forums SQLServerCentral.com Anything that is NOT about SQL! What do you look for in a Database Audit? RE: What do you look for in a Database Audit?

  • December 26, 2008 at 11:39 am

    #917888

    rajib (12/26/2008)

    I love the word "depends". 😀

    How about we assume that I'm looking for everything (3 things mentioned above as well as other items not listed there)? I am interested in learning what others have done in their projects. That's all.

    Then I believe it's going to boil down to what I said... those 3 things, a viable audit trail for all changes, and security. On the security side for things like SEC and SOX audits, you'll be asked to prove that not even DBA's can change the data without an audit trail being left. That's just about impossible unless you have a shop where the DBA's don't have SA access.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)