locked
I want to do audit for a particular user for particular database . RRS feed

  • Question

  • I want to do audit for a particular user for particular database .

    Is it possible?


    Thanks

    Thursday, November 1, 2012 9:24 AM

Answers

All replies

  • Turn on SQL Profiler and filter out for database and sessionid/username

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    MS SQL Consultants: Improves MS SQL Database Performance

    Thursday, November 1, 2012 9:40 AM
  • You can use sql profiler for the same. You can script & create server side trace.

    Refer Link : http://msdn.microsoft.com/en-us/library/ms181091.aspx


    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Thursday, November 1, 2012 10:57 AM
  • I thunk it will make sql server speed slow and in audit performance will be good.


    Thanks

    Thursday, November 1, 2012 1:01 PM
  • If you use a server side trace file it won't hurt over all perfromance

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    MS SQL Consultants: Improves MS SQL Database Performance

    Thursday, November 1, 2012 1:11 PM
  • As Uri said you can also apply filters to further reduce any chance of performance issues caused by SQL Profiler. This can include de-selecting Coloumns and Events as follows; -


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com/ http://uk.linkedin.com/in/kieranpatrickwood

    Thursday, November 1, 2012 1:38 PM
  • If I will use profiler then A session will never be close from the server and if any one logoff it then my audit will be finished.can i run trace as a service so that it shouldn't affected with session logoff.


    Thanks

    Monday, November 19, 2012 8:48 AM