SQL Server Auditing problem

• navtec

  Hall of Fame

  Points: 3206

  More actions

  February 6, 2014 at 3:32 am

  #289212

  Hi,

  I have created some auditing on SQL Server 2008 R2.

  It checks for select statements which are executed against a particular database table.

  It is a database audit specification.

  When I go into my database audit specification, and try and change the principal name from Public to something else the audit stops working.

  I have set it up by choosing 'Object' in the Object class, 'dbo' in the Object schema, my object name is my test table which I'm executing select statements against and the principal name is Public.

  I have a group in Active Directory and have created a windows login in SQL Server which points at this group.

  It has 'sysadmin' permissions.

  How can I use this group in my audit's principal name instead of PUBLIC?

  Thanks.