Page History
IDERA SQL Compliance Manager allows users to edit the Use the Edit Server Default Audit Settings in order to comply with their auditing needs.
provides users with a default basic set of settings to begin auditing. These are just the Idera default settings, and users can modify these settings on individual servers and databases to accommodate their auditing needs. These settings will apply to newly added servers and databases. Users can reset back to the Idera default settings at any time by clicking the Reset to Idera Default Settings button.
IDERA Default Server Audit Settings
Audited Activities tab
Allows you to select the type of activity you want to audit. The following are the IDERA Default Database Audit Settings:
- Failed Logins
- Access Check Filter - Filter events based on access check
- Audit only actions that passed access check
- Capture DML and Select Activities
- Via Trace Events
Trusted Users tab
No users selected
Privileged Users Auditing tab
No users selected
Auditing Thresholds tab
No settings enabled
Advanced tab
- Default Database Permissions
- Grant right to read events and their associated SQL statements
- SQL Statement Limit
- Truncate stored SQL statements after 512 characters
options to configure your Server Default auditing needs exactly the way you want without having to make additional updates to your configurations.. The Default Server Settings can later be applied to your registered servers or to newly added SQL Servers.
To Edit Server Default Audit Settings follow the steps below:
- From the Administration view, select the Default Audit Settings tab.
- Click the Edit Server Default Audit Settings option.
- Set your desired SQL Server Default Audit Settings, for more information on how to configure these settings, visit the SQL Server Default Audit Settings page.
- Once done configuring your desired settings, Click Save.
Users can reset back to the Idera Default Audit Settings at any time by clicking the Reset to Idera Default Settings button.
...