Page History

...

• Control the default permission settings on the databases that contain audit data for this SQL Server instance.
• Indicate whether collected SQL statements should be truncated if they pass the specified character limit. This option is only available if you are auditing SQL statements executed at the server level on this instance.
  
  Image Added

Available fields

Default Database Permissions

Allows you to set the default permissions on the databases that contain audit data for this instance. Keep in mind that login permissions specified at the database are applied along with the default permissions you set here. You can select one of the following default permissions:

• • • Grant permission right to view read events and their associated SQL statements.
    • Grant permission right to view read events only - To allow users to view the associated SQL statements, you will need to explicitly grant users read access to the database.
    • Deny read access by default  - To allow users Deny permission to view events or and the associated SQL statements, you will need to explicitly grant users read access to the database. 

SQL Statement Limit

Allows you to specify whether you want to truncate collected SQL statements associated with audited events. You can set the character limit for collected SQL statements. By default, this limit is 512 characters. The Collection Server truncates SQL statements that are longer than the specified character limit.