sql server Audit problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » sql server Audit problem

sql server Audit problem

Rate Topic

Display Mode

Topic Options

Author

Message

k.thanigaivel

Posted Monday, October 01, 2012 3:25 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 12:01 AM
Points: 45, Visits: 851

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?

Post #1366415

k.thanigaivel

Posted Monday, October 01, 2012 7:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 12:01 AM
Points: 45, Visits: 851

Hi,

Any idea?

Post #1366551

Randall F Smith

Posted Monday, October 08, 2012 11:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 08, 2012 11:35 AM
Points: 4, Visits: 9

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 www.ultimateWindowsSecurity.com/sqlserver and at www.logbinder.com/products/logbindersql.

Post #1369973

« Prev Topic | Next Topic »

Permissions