Auditing a Table for Select Statement By Active Directory User

  • 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