Page History
IDERA SQL Secure includes built-in reports which have been specially designed to generate commonly requested audit reports using the SQL Server permission data collected in your snapshots.
SQL Secure built-in reports allow you to quickly and easily meet the demands of on-the-spot audits, routine audits, and long-term event trending. Each report gives provides detailed information about events in your SQL Server environment.
...
Report Name | Report Description | ||
---|---|---|---|
Audited SQL Servers | Displays all the SQL Server instances that are being audited by SQL Secure | ||
Cross Server Login Check | Displays all SQL Server instances where a selected user has access | ||
Data Collection Filters | Displays the data collection filters for all SQL Server instances | Activity History | Displays all SQL Secure activity history |
Risk Assessment | Displays all policy and risk assessment results. You can customize this text using the Policy Properties window. For more information, see Internal Review Notes. | ||
Activity History | Displays all SQL Secure activity history | ||
SQL Secure Users | Displays all SQL Secure users |
...
Report Name | Report Description |
---|---|
Suspect Windows Accounts | Displays all the suspect Windows Accounts that have Server Logins or Server Files Permissions. For more information, see Suspect Windows accounts. |
Suspect SQL Logins | Displays all the suspect SQL Server Accounts that do not have any assigned permissions, i.e. databases, objects, or server files. |
Server Logins and User Mappings | Displays all Server Logins and associated Database User Mappings for each SQL Server instance being audited |
User Permissions | Displays permissions for a user across all SQL Server instances |
All User Permissions | Displays all objects with permissions in the database for all SQL Server instances |
Server Roles | Displays all direct members of Server Roles on all SQL Server instances |
Database Roles | Displays all direct members of Database Roles on all SQL Server instances |
...