Security Resources

Software Updates

Database Security Knowledgebase Update 5.35

Knowledgebase version 5.35 includes new checks for MySQL, PostgreSQL and Oracle, updated checks for MySQL and Sybase ASE and finally several updated policies. It has also introduced three new policies for CIS and DISA-STIG. Finally, it has updated the Microsoft SQL Server Database Power User Creation Script.

New Vulnerability and Configuration Check Highlights

MySQL

  • Critical Patch Update - October 2018
    • Check version to determine if the database contains vulnerabilities described by Critical Patch Update - October 2018.
    • Risk: High
  • Ensure default port is not used
    • Verify that the server is not running on default port.
    • Risk: Low
  • Server Information
    • Reports server information.
    • Risk: Informational

Oracle

  • Critical Patch Update/Patch Set Update - October 2018
    • Check version to determine if the database contains vulnerabilities described by Critical Patch Update/Patch Set Update - October 2018.
    • Risk: High

PostgreSQL

  • Ensure backend runtime parameters are configured correctly
    • Verify the backend runtime parameters for the PostgreSQL database are configured correctly.
    • Risk: Medium
  • Ensure excessive DML privileges are revoked
    • Verify that authorized users have the appropriate DML privileges on tables.
    • Risk: Medium
  • Ensure login via local UNIX Domain Socket is configured correctly
    • Verify that to properly set up the local UNIX Domain Socket, within the pg_hba.conf, that TYPE = 'local' and that METHOD = 'peer'
    • Risk: Medium
  • Ensure miscellaneous configuration settings are correct
    • Verify that the miscellaneous configuration settings are configured correctly.
    • Risk: Medium
  • Ensure PostgreSQL configuration files are outside the data cluster
    • Ensure PostgreSQL configuration files are outside the data cluster.
    • Risk: Medium
  • Ensure PostgreSQL subdirectory locations are outside the data cluster
    • Verify that the PostgreSQL configuration directories are located outside the data cluster.
    • Risk: Medium
  • Ensure Postmaster Runtime Parameters are Configured
    • Verify the postmaster runtime parameters for the PostgreSQL database are configured correctly.
    • Risk: Medium
  • Ensure Row Level Security is configured correctly
    • Verify that the tables within the database designated with Row Level Security are configured correctly.
    • Risk: Medium
  • Ensure SIGHUP Runtime Parameters are Configured
    • Verify the sighup runtime parameters for the PostgreSQL database are configured correctly.
    • Risk: Medium
  • Ensure SSL Certificates are Configured For Replication
    • Verify that the following PostgreSQL options are ENABLED: ssl, ssl_cert_file, ssl_key_file.
    • Risk: Medium
  • Ensure Superuser Runtime Parameters are Configured
    • Verify the superuser runtime parameters for the PostgreSQL database are configured correctly.
    • Risk: Medium
  • Ensure the correct messages are written to the server log
    • Verify that the PostgreSQL option log_min_messages is configured in accordance to your organization's logging policies.
    • Risk: Medium
  • Ensure the filename pattern for log files is set correctly
    • Verify that the PostgreSQL option log_filename is in accordance with your organization's logging policy.
    • Risk: Medium
  • Ensure the maximum log file lifetime is set correctly
    • Verify that the PostgreSQL option log_rotation_age is ENABLED.
    • Risk: Medium
  • Ensure the maximum log file size is set correctly
    • Verify that the PostgreSQL option log_rotation_size is ENABLED.
    • Risk: Medium
  • Ensure the PostgreSQL pg_wheel group membership is correct
    • Verify that the PostgreSQL group 'pg_wheel' exists AND that the user a part of that group are authorized.
    • Risk: Medium
  • Ensure User Runtime Parameters are Configured
    • Verify the user runtime parameters for the PostgreSQL database are configured correctly.
    • Risk: Medium
  • Ensure WAL archiving is configured and functional
    • Verify that WAL archiving is configured and functional by ensuring parameter archive_mode is ENABLED and archive_command is correct.
    • Risk: Medium

Updated Checks 

MySQL

  • Latest release not installed
    • Support MySQL 5.5.62, 5.6.42, 5.7.24
    • Risk: High
  • Release update not installed on time
    • Support MySQL 5.5.62, 5.6.42, 5.7.24
    • Risk: High 

Sybase ASE

  • Latest patch not applied
    • Support SAP ASE 16.0 SP03 PL05 HF1
    • Risk: High
  • Patch not applied on time
    • Support SAP ASE 16.0 SP03 PL05 HF1
    • Risk: High 

New Policies

  • CIS v1.0.0 for PostgreSQL 9.5 - Audit (Built-In)
    • This policy has been created with guidance of the security configuration benchmarks for PostgreSQL 9.5 by the Center for Internet Security.
  • DISA-STIG SQL Server 2014 V1R6-9- Audit (Built-in)
    • This policy has been created with guidance of the configuration parameters outlined by the DISA-STIG Microsoft SQL Server 2014 Security Technical Implementation Guide Database V1R6 and Instance V1R9.
  • DISA-STIG Oracle 12c V1R11 - Audit (Built-in)

This policy has been created with the guidelines mapped out in the DOD Security Technical Implementation Guides "Oracle Database 12c Security Technical Implementation Guide Version 1 Release 11".

Updated Policies

  • Base Line - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Basel II - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Basel II - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Best Practices for Federal Gov. - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • CIS v1.0.0 for MySQL 5.7 - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
  • CIS v1.0.0 for Oracle 11gR1&R2 - Audit (Built-in)
    • New Checks
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • CIS v1.0.2 for MySQL 5 - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
  • CIS v2.0 for Oracle 12c - Audit (Built-In)
    • New Checks
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • CIS v2.2.0 for Oracle 11gR2 - Audit (Built-In)
    • New Checks
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • CNIL - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • DISA-STIG Database Security - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • DISA-STIG Oracle 11gR2 V1R14 - Audit (Built-in)
    • New Checks
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • DISA-STIG Oracle 12c V1R10 - Audit (Built-in)
    • New Checks
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Database Best Practices
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • EU Data Protection Directive - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • EU Data Protection Directive - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • FISMA - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • FISMA - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • FedRAMP - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Full - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Gramm-Leach-Bliley Act - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Gramm-Leach-Bliley Act - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • HIPAA - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • HIPAA - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Heavy - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Integrity - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • MITS - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Massachusetts 201 CMR 17.00
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Medium - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • MiFID - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • MiFID - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • PCI Data Security Standard - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • PCI Data Security Standard - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Safe - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Sarbanes-Oxley - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Sarbanes-Oxley - Pen Test (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
  • Strict - Audit (Built-in)
    • New Checks
      • MySQL: Critical Patch Update - October 2018: High
      • MySQL: Ensure default port is not used: Low
      • MySQL: Server Information: Informational
      • Oracle: Critical Patch Update/Patch Set Update - October 2018: High
      • PostgreSQL: Ensure the correct messages are written to the server log: Medium
      • PostgreSQL: Ensure the maximum log file size is set correctly: Medium
      • PostgreSQL: Ensure the maximum log file lifetime is set correctly: Medium
      • PostgreSQL: Ensure the filename pattern for log files is set correctly: Medium
      • PostgreSQL: Ensure the PostgreSQL pg_wheel group membership is correct: Medium
      • PostgreSQL: Ensure excessive DML privileges are revoked: Medium
      • PostgreSQL: Ensure Row Level Security is configured correctly: Medium
      • PostgreSQL: Ensure login via local UNIX Domain Socket is configured correctly: Medium
      • PostgreSQL: Ensure backend runtime parameters are configured correctly: Medium
      • PostgreSQL: Ensure User Runtime Parameters are Configured: Medium
      • PostgreSQL: Ensure SIGHUP Runtime Parameters are Configured: Medium
      • PostgreSQL: Ensure Superuser Runtime Parameters are Configured: Medium
      • PostgreSQL: Ensure Postmaster Runtime Parameters are Configured: Medium
      • PostgreSQL: Ensure SSL Certificates are Configured For Replication: Medium
      • PostgreSQL: Ensure WAL archiving is configured and functional: Medium
      • PostgreSQL: Ensure PostgreSQL configuration files are outside the data cluster: Medium
      • PostgreSQL: Ensure PostgreSQL subdirectory locations are outside the data cluster: Medium
      • PostgreSQL: Ensure miscellaneous configuration settings are correct: Medium

User Creation Scripts

  • SQL Database Power User Creation script was updated.

Availability

  • Available to all AppDetectivePRO and DbProtect customers with maintenance (subscription or perpetual) in good standing at no additional cost.
  • Download SHATTER Knowledgebase from the Trustwave Support Portal. (https: //www.trustwave.com/Company/Support/and select AppDetectivePRO or DbProtect)
  • AppDetectivePRO customers can use the Updater within the product as well