Unable to Set Up a Table Audit in Multiple Audit Groups

Issue:

You are unable to set up a table audit in more than one Audit Group.

Resolution:

A given table can exist in only one Audit Group at any time. The reason for this is because it would be too hard to tell which one wants what tracked, could produce duplicate triggers, and overall would be cumbersome to manage and report on.

You can have a Table Audit and SQL Table Audit on the same table.

Related Content