locked
SQL Server Auditing to an AD Group RRS feed

  • Question

  • Hi Folks,

    we are looking to setup sql auditing to trace out the operations which are being perfromed by the users form an AD Group instead of a single/public user. Can someone please assist me in the above scenario?

    SQL Servr version is 2008 SP2


    Regards; Sureddy; Database Administrator


    • Edited by Chreddy S Monday, October 29, 2012 2:01 PM
    Monday, October 29, 2012 2:00 PM

Answers

  • In sql profiler filter of option NTDomainName may help you


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by Maggie Luo Monday, November 5, 2012 8:44 AM
    Thursday, November 1, 2012 4:55 AM

All replies

  • In sql profiler filter of option NTDomainName may help you


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by Maggie Luo Monday, November 5, 2012 8:44 AM
    Thursday, November 1, 2012 4:55 AM
  • You can use SQL profiler for the same. you can put sql filter on ntdomainname.

    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:56 AM
  • Thanks for your reply.

    I would like to let you know that we are trying to configure auditing by using the Server Level Audit Specifications and Database Level Audit Specifications, not using the SQL Profiler. Any ideas using these ways?


    Regards; Sureddy; Database Administrator

    Monday, November 5, 2012 11:04 AM