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?