Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Exclude a specific table from an audit Expand / Collapse
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: Friday, October 24, 2014 8:56 PM
Points: 365, Visits: 699
We have a database audit spec with these three audit actions:

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