Post reply

audit account

  • November 17, 2016 at 3:31 pm

    #401076

    We have a sql server database hosted on a vendor site. We were ask to do audit.

    What kind of permission should i request from the vendor for audit purposes?

    We need to know the following:

    - when an user account was create/deleted/modified

    - when objects were create/deleted/modified

    i am thinking of an admin account but read only.

    thanks.

  • November 17, 2016 at 10:17 pm

    #1913282

    To be brutally honest, if you don't know which permissions to request for this audit, then you're probably not qualified to do the audit.

    --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)

  • November 18, 2016 at 1:30 am

    #1913330

    If you place only database to hosting there is no reason to make an account for audit in database. Because all changes can be tracked correctly only on SQL server instance level.

    So, you need to ask your hosting vendor to make this audit and tell them what information do you actually need.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply