Page History

IDERA SQL Secure provides the following new features and fixed issues.

...

4.

...

0 New features

• Anchor
  SQLSECU-27592783 SQLSECU-27592783

  The time to keep snapshots before letting them be groomed is no longer set by default to one day when importing files in CSV format SQL Secure Data Collector Job Keys allow you to manage snapshot collection jobs. Use this option to throttle the collector jobs so that they do not overload the SQL Server instance.

• Anchor
  SQLSECU-27582763 SQLSECU-2758

  The User Permission report is no longer showing errors in the db_role information.

  2763

  SQL Secure supports TLS 1.2 to send email requests to SMTP.

4.0 Fixed issues

• Anchor
  SQLSECU-27572704 SQLSECU-2757

   

  2704

  SQL Secure enhanced the assessment's loading time; they no longer take several minutes to display informationThe User Permissions report shows all schema level permissions data. The Object Type filter is no longer generating blank spaces after any object type name.

• Anchor
  SQLSECU-27442778 SQLSECU-2744

   

  2778

  Snapshot collection on Availability Group Nodes no longer generates a file permissions warning messageYou can access registry key information and the SQL Server install folder with Local Administrador and Sysadmin permissions. The Snapshot collection is no longer displaying warning messages caused by permissions on the SQL Server instance.
  

• Anchor
  SQLSECU-27352779 SQLSECU-2735

  "Orphaned users" security check is no longer identifying users without matching logins as orphan users

  2779

  Snapshot collection completes successfully for a log-shipped database.

• Anchor
  SQLSECU-26782716 SQLSECU-2678

  The All User Permissions report now allows you to expand or collapse results upon report execution. When the report has many permission results, displaying the results collapsed will allow the report to complete execution faster while permissions can be expanded and explored for each audited database

  2716

   The number of Stored Procedures in the Stored Procedures Encrypted details of the security check no longer differs from the number of Stored Procedures in SSMS.

• Anchor
  SQLSECU-26762777 SQLSECU-26762777

  SQL Secure no longer displays timeout errors while generating the Database Roles Reports.

• Anchor
  SQLSECU-2781 SQLSECU-2781

  Renaming and disabling sa login account no longer shows a "sa Account Not Disabled" security checkGenerating the Database Roles report is no longer causing a "maximum recursion" error message.

• Anchor
  SQLSECU-26082780 SQLSECU-26082780

  SQL Secure fixed the "Is the SQL Server sa account enabled"Public Server Role only granted default Microsoft permissions" security check shows the correct information related to have a passed status when the finding is "The sa account is not enabled".

...

• Server Roles

• Anchor
  SQLSECU-2589 SQLSECU-2589

  The Snapshot Comparison Report no longer displays server changes when no changes have been made.

• Anchor
  SQLSECU-2774 SQLSECU-2774

  The User Permission Report works correctly with different collations set.

• Anchor
  SQLSECU-26872762 SQLSECU-26872762

  SQL Secure adds a DISA-NIST STIG policy and security check templates for SQL Server 2016, with 11 security checks enabled by default.imports hidden instances using CSV files.

• Anchor
  SQLSECU-2788 SQLSECU-2788

  Anchor
  SQLSECU-

  2557

  2766 SQLSECU-

  2557 An additional policy field filtering option was implemented in the Assessment Comparison report.

...

• 2766

  The Snapshot collection process completes successfully for imported instances using CSV files.

• Anchor
  SQLSECU-2771 SQLSECU-2771

  Anchor
  SQLSECU-26792766 SQLSECU-2679

  The error message where "SQL Secure was unable to acquire a valid key" is no longer displayed while trying to take snapshots after decommissioning some servers

  2766

  The Risk Assessment Report no longer reports the sa login account incorrectly.

• Anchor
  SQLSECU-26882793 SQLSECU-26882793

  The SQL Mail or Database Mail Enabled security check now is working as expectedSQL Secure no longer has issues with bulk email notification settings.

• Anchor
  SQLSECU-26892772 SQLSECU-26892772

  Renaming the sa login in a SQL Server instance no longer generates a false warning risk level in the 'sa account is not disabled' checkAddressed several areas causing poor performance and usability in the user permissions report with significant success.

• Anchor
  SQLSECU-27112774 SQLSECU-2711

  Streamlined workflow for the snapshot data collection operation

  2774

  SQL Secure enhanced the SQL Job Permission security check.