sql server Audit problem

• k.thanigaivel

  Ten Centuries

  Points: 1247

  More actions

  October 1, 2012 at 3:25 am

  #393285

  Hi,

  I have created one database level audit to monitor select on table "Bet". This audit works only when principal name is "dbo", It does not work if any other user is selected. is it possible to create audit on particular user? what setting we have to check to enable user level audit?

• k.thanigaivel

  Ten Centuries

  Points: 1247

  More actions

  October 1, 2012 at 7:11 am

  #1543966

  Hi,

  Any idea?

• Randall F Smith

  Grasshopper

  Points: 24

  More actions

  October 8, 2012 at 11:42 am

  #1546863

  I thought I already responded to this but maybe it was a different forum. You need to change your audit entry in the Principal Name column from dbo to something like public. BTW, I've written a lot about SQL Auditing at http://www.ultimateWindowsSecurity.com/sqlserver and at http://www.logbinder.com/products/logbindersql.