Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Auditing a Table for Select Statement By Active Directory User Expand / Collapse
Posted Tuesday, March 19, 2013 3:10 PM


Group: General Forum Members
Last Login: Wednesday, March 20, 2013 8:39 AM
Points: 18, Visits: 46
Hey guys,

I'm attempting to set up auditing on a table in my database. Under the database audit specification properties GUI, I have
Audit Action Type "Select"
Object Class "Object"
Object Schema "dbo"
Object Name "ImportantTable"
Principal Name "OurNetworkDomain\Me"

With this current setup, I perform a
Select * From ImportantTable

However the audit log does no logging. If I change the principal name to "Public" or "dbo" it correctly logs my activity and even shows under "Session Server Principal Name" and "Server Principal Name" columns that I am coming from OurNetworkDomain\Me

I don't want to use dbo or Public as it will collect way too much information. Any ideas why this doesn't work when I just specify the Active Directory user individually?

Post #1432910
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse