Page History

...

Select the activities you want to audit, and then click Next.

Image Added

Available actions

Audit all activities done by privileged users

...

Allows you to specify which activities (events) you want to audit for the selected privileged users. Available options include:

• • • Logins
    • Logouts
    • Failed logins
    • Security changes
    • Administrative actions
    • Database definition (DDL)
    • Database modification (DML)
    • Database SELECT operations
    • User defined events
    • Filter events based on access check.

Capture SQL statements for DML and SELECT activity

...

Ensure the Collection Server and the target SQL Server computers have ample resources to handle the additional data collection, storage, and processing. Because this setting can significantly increase resource requirements and negatively impact performance, choose this setting only when your compliance policies require you to audit transaction status, such as rollbacks.

Capture SQL statements for DDL and Security Changes

Allows you to specify whether you want to collect SQL statements associated with audited database definition (DDL) activities. To capture these statements, you must also enable DDL auditing.

Ensure the Collection Server and the target SQL Server computers have ample resources to handle the additional data collection, storage, and processing. Because this setting can significantly increase resource requirements and negatively impact performance, choose this setting only when your compliance policies require you to audit SQL statements.

...