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.
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.
| Excerpt |
|---|
SQL Compliance Manager audits all activity on your server. Learn more > > |
...
Add New Databases Automatically
Selecting this checkbox will automatically add newly created databases to your list of audited databases for the selected server. Database Default Audit Settings will be apply to the newly created databases, you can update the Database Default Audit Settings at any time.
...