Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Exclude a specific table from an audit Expand / Collapse
Author
Message
Posted Friday, March 1, 2013 2:05 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 11:41 AM
Points: 365, Visits: 692
We have a database audit spec with these three audit actions:
ADD (DATABASE_OBJECT_ACCESS_GROUP),
ADD (SCHEMA_OBJECT_ACCESS_GROUP),
ADD (AUDIT_CHANGE_GROUP)

Our database has 250 tables in it. We chose to use database_object_access_group instead of auditing specific tables. However, now we would like to exclude two specific tables from the audit. We could list all of the tables (but 2) in the audit. However, if we add a new table to the DB, I am afraid we will forget to add the new table to the audit.
Is there a good (a.k.a. simple) way of auditing user access to all but 2 tables (including newly added tables)?
Post #1425737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse