SQL Compliance Manager v6.2

Released: Feb 20, 2024

Mises à jour de v6.2

Fonctionnalités

Quality Enhancements

  • Enhanced User Experience with Email and Summary Notifications - Improved how you determine if an Alert Rule has been configured as 'Email Notification' or 'Email Summary Notification'. The rule description has been enhanced to make it convenient to distinguish between the two without the need for alert rule modifications.
  • Command Line Interface (CLI) Enhancement - Added a CLI command line for registering a server, grooming, archiving, and verifying audit data integrity - SQL Compliance Manager is now augmented with CLI for enabling and disabling auditing servers.
  • Reports - Improved and added the number of rows at the end of the reports to ease access to the information contained in each report.

Security Enhancements

  • Encryption - Enhanced security by deploying a strong Advanced Encryption Standard (AES) algorithm to meet the latest high standards of large enterprise customers. The Advanced Encryption Standard (AES) is an algorithm that uses the same key to encrypt and decrypt protected data. Instead of a single round of encryption, data is put through several rounds of substitution, transposition, and mixing to make it harder to compromise.

Correctifs

  • DDL, DML, and DROP events are now correctly shown in the "Audit Events" tab after performing the DDL action on the "Sensitive Column" when using the "via Audit Logs" collection method.
  • Audit events for "insert" are now accurately being recorded for Sensitive columns with "select and DML activity" enabled.
  • Resolved the issue where Trace events were not being correctly captured for "delete from <table>" audit events when sensitive columns with "select and DML activity" were configured.
  • Fixed an issue where the number of Logout events captured was significantly more than the number of Login events.
  • Resolved the issue where a warning message was displayed in the Event Viewer after execution of the trace file out to the collection Server for processing.
  • Fixed an issue where the "Delete" DML events were shown twice after executing a single "Delete" query on the "Sensitive Columns" table when "Trace" or "Audit Logs" collection methods were used.
  • Resolved the issue where the events table integrity check did not detect changes done on hash columns.
  • The "SQL Statement" content is now correctly displayed in the "Event Properties" after executing the DDL query if the "via SQL server Audit specification" is used.
  • Resolved the issue where the "+" icon was missing for the DDL column-sensitive event in the "Audit Events" tab.
  • Addressed an issue where the layout was broken for reports downloaded in PDF and TIF formats.
  • Resolved an issue where Events were not captured as expected with Extended Events and SELECT auditing was enabled.
  • Fixed the issue where the Bin file was not getting updated for the Privileged User set up through a domain group at the server level.
  • Resolved an issue where "Unknown Publisher" was displayed in the "User Account Control" when installing SQLCM.
  • Addressed an issue where an error message would come up when trying to import audit settings.