Page History
This tab The Before-After Data tab of the Audited Database Properties window allows you to select the tables for which you want to collect before and after data. You can collect before and after data for DML events generated by DELETE, INSERT, and UPDATE commands.
...
| Info |
|---|
| Info |
|---|
To successfully audit specific columns on a table, ensure the table name does not contain the following special characters: \ / : * ? " |
Available actions
Specify tables for before and after data collection
Use Add and Remove to specify the tables for which you want to collect before and after data.
...
Use Edit to select the number of rows per transaction that you want to audit from this table. For example, if you select 100 rows, the SQLcompliance SQL Compliance Manager Agent will capture the first 100 rows of each DML transaction, and collect all column updates for each captured row. By default, the first 10 rows per DML transaction are captured.
...
Provides the maximum number of rows that the SQLcompliance SQL Compliance Manager Agent will capture of each DML transaction.
...
- Ensure Database Modification (DML) activity is selected on the Audited Activities tab.
- Ensure the appropriate tables are specified on the DML/SELECT Filters tab.
- On the Before-After Data tab, click Add to choose which audited tables should also be audited at the column level for before and after data.
- Choose the appropriate tables, and then click OK. By default, all columns are audited.
- If you want to audit specific columns, select the table, and then click Edit.
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Compliance Manager audits all activity on your server. Learn more > >
...
...