Post reply

Audti Trial for a single user

  • August 24, 2009 at 9:47 pm

    #213734

    Hello

    For business requirements I want to create another sysadmin account called "sa2" and give it to the Software Developers/Business Analysts to use so they can perform their duties. What I want to do is implement a audit trail for that user only to capture any update/delete as well as creating databases, indexes, fields etc...pretty much everything for that user. We use SQL 2005 and 2008.

    Have anyone done this before? Your help/advice is muchly appreciated.

    Thanks

    Brandon

  • August 26, 2009 at 2:36 pm

    #1045176

    By audit trail you mean sql profiler trace? You can track all these activities in the sql trace. Use the blank template and put the filters on loginname and the the operations you want to track.

  • August 26, 2009 at 7:14 pm

    #1045285

    Hi

    Thanks for your advice.

    I prefer not to use Profiler as it can consume CPU...and I want to be able to run this constantly.

    Any other suggestions is appreciated.

    Regards

    Brandon

  • August 27, 2009 at 2:25 am

    #1045374

    WAGalaxy (8/24/2009)

    Hello

    For business requirements I want to create another sysadmin account called "sa2" and give it to the Software Developers/Business Analysts to use so they can perform their duties. What I want to do is implement a audit trail for that user only to capture any update/delete as well as creating databases, indexes, fields etc...pretty much everything for that user. We use SQL 2005 and 2008.

    Have anyone done this before? Your help/advice is muchly appreciated.

    Thanks

    Brandon

    First thing I would ask, is why a sysadmin account, is this on a production server or on a test/development box. if you can lower the permissions needed for this user. then what you will need to audit with be smaller.

    you can use audits in sql 2008 or in sql 2005, you can use server triggers. but both include quite a bit of work to implement properly.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

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

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