Page History
...
Warning |
---|
IDERA, Inc. customers have the sole responsibility to ensure their are solely responsible for ensuring compliance with the laws and standards affecting their business. IDERA, Inc. does not represent that its products or services ensures ensure that customer is in compliance with any law. It is the responsibility of the customer to obtain legal, accounting, or audit counsel as to the necessary business practices and actions to comply with such laws. |
...
6.
...
3 New Features
Supports SQL Server 2019
IDERA SQL Compliance Manager 5.7 now supports installation of the Database Repository for Collection Server, deployment of the SQL Compliance Manager Agent, and auditing events for SQL Server 2019. For more information, see Software requirements.
Supports Windows Server 2019
The user can install IDERA SQL Compliance Manager 5.7 and deploy the SQL Compliance Manager Agent in Windows Server 2019. For more information, see Software requirements.
Reports
New Reports
SQL Compliance Manager version 5.7 includes the Server Activity Report which allows users to view the SQL Server activity at the enterprise and at the individual instance levels. With this report, users can quickly check activity in each event category audited, and view statistics of the SQL Server activity. For more information, see Server Activity Report Card.
SQL Compliance Manager version 5.7 includes the Privileged/Trusted Users Report for users to list the trusted and privileged user roles set per a specific Server or Database. Users can run this report on Privileged and Trusted users to know what these were set to during a snapshot in time. For more information, see Privileged and Trusted Users Report.
SQL Compliance Manager version 5.7 includes the Sensitive Column/BAD Users Report which lists Sensitive Columns and Before-After data audit settings applied to the servers and databases in your environment. Users can run this report on Sensitive Columns and BAD auditing to know what these were set to during a snapshot in time. For more information, see Sensitive Columns and BAD Report.
Limit Report Access to specific users
SQL Compliance Manager version 5.7 introduces the ability to restrict user access to certain SQL CM reports. As an administrator you can grant users permissions to specific reports. This way you can tightly control permissions settings for report access for every user in your environment. For more information, see Login properties - Report Access.
Report Filter improvements
SQL Compliance Manager version 5.7 brings updates and improvements to reports by making reports more consistent and adding new filters options, such as the ability to filter reports based on a specific schema, event type, login, or multiple logins at a time. Users can also use the time range filters to report on the exact high activity time-frames or to filter out low activity time-frames.
5.7 Fixed Issues
Security Enhancements
Anchor | ||||
---|---|---|---|---|
|
SQL Compliance Manager 6.3 release delivers security permissions based on the least privilege principle (as opposed to permissions based on standard user roles such as sysadmin) to further enhance the data security per user within the product.
6.3 Fixed Issues
-
Fixed an issue where DDL events were not being captured for server-level privilege users configured through a domain group.Anchor SQLCM-6883 SQLCM-6883 -
Resolved the issue where the Regulatory Compliance Check report was showing "No" at server-level for PCI DSS guideline.Anchor SQLCM-6364 SQLCM-6364 -
Fixed an issue where the IP Address Auditing checkbox was unchecked after importing an exported audit setting file.Anchor SQLCM-6860 SQLCM-6860
-
Addressed an issue with Audit Events not appearing on SQLCM console when CM repo was hosted on a Case Sensitive SQL instance.Anchor SQLCM-6855 SQLCM-6855 -
Solved the issue of multiple alerts being logged for a single event.Anchor SQLCM-6816 SQLCM-6816 - The number of Data and Event alerts is consistent with the number of audit events generated.
- The email alerts have been improved with the appropriate event description.
Anchor SQLCM-5505 SQLCM-5505 The Object Activity Report no longer renders all data on a single page, and when run, the report displays the collected data correctly.
For more information about new features and fixed issues in versions 5.version 6.x3, see see Previous new features and fixed issues.
...