Post reply

Database Audit Specification on Columns?

  • February 2, 2009 at 9:18 am

    #200874

    According to BOL for 2008, you can turn on auditing on a column. However, when trying the following example, this does not work. Any ideas?

    http://msdn.microsoft.com/en-us/library/cc280645.aspx

    Example

    ALTER DATABASE AUDIT SPECIFICATION HIPPA_Audit_DB_Specification

    FOR SERVER AUDIT HIPPA_Audit

    ADD (SELECT

    ON Table1(Column1)

    BY dbo)

    WITH STATE = ON;

    GO

  • February 2, 2009 at 9:30 am

    #936506

    Have you created the Server Audit HIPPA_Audit? Also, are you testing against either SQL Server 2008 Enterprise Edition or Developer Edition? If not, the Audit object is only for EE (and Developer is a specially licensed version of EE, so that's why it works there).

    K. Brian Kelley
    @kbriankelley

  • February 2, 2009 at 9:41 am

    #936521

    I tried the example in BOL. After creating the server audit and auditing data at the table level, I modified the syntax to include the column. I don't recall the exact message, I don't have access to that system from my current location. It said something about the functionality not being available at that level - but BOL clearly shows that it is.

    The GUI also did not show any options for modifying the audit to the column level.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply