March 19, 2013 at 3:10 pm
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?
Thanks!
Andrew
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy