Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 detailed information about events in your SQL Server environment.

Note

Using the Console to generate reports against large audit data sets can result in degraded performance. For example, when the selected snapshot is large (contains thousands of objects and permissions), the report performance may be impacted. If you experience degraded performance , try increasing the Console timeout value and, if the performance issues continue, run the report with Microsoft Reporting Services instead.

Generate a report

To report on audit data:

  1. In the console tree pane, click Reports.
  2. In the view pane, select the report you want to generate.
  3. Specify the appropriate parameters for the selected report and then click Apply.

Available general reports

Report NameReport Description
Audited SQL ServersDisplays all the SQL Server instances that are being audited by SQL Secure
Cross Server Login CheckDisplays all SQL Server instances where a selected user has access
Data Collection FiltersDisplays the data collection filters for all SQL Server instances
Risk AssessmentDisplays all policy and risk assessment results. You can customize this text using the Policy Properties window. For more information, see Internal Review Notes.
Activity HistoryDisplays all SQL Secure activity history
SQL Secure UsersDisplays all SQL Secure users

...

Report NameReport Description
Suspect Windows AccountsDisplays all the suspect Windows Accounts that have Server Logins. For more information, see Suspect Windows accounts.
Server Logins and User MappingsDisplays all Server Logins and associated Database User Mappings for each SQL Server instance being audited
User PermissionsDisplays permissions for a user across all SQL Server instances
All User PermissionsDisplays all objects with permissions in the database for all SQL Server instances
Server RolesDisplays all direct members of Server Roles on all SQL Server instances
Database RolesDisplays all direct members of Database Roles on all SQL Server instances

...

Report NameReport Description
Assessment ComparisonDisplays any differences identified in the security settings and findings of two assessments.
Snapshot ComparisonDisplays any differences identified in the configuration settings and audit data of two snapshots.

...

Excerpt
SQL Secure tells you who has access to what on your SQL Server databases. Learn more > >