Trustwave and Cybereason Merge to Form Global MDR Powerhouse for Unparalleled Cybersecurity Value. Learn More

Request a Demo

Trustwave and Cybereason Merge to Form Global MDR Powerhouse for Unparalleled Cybersecurity Value. Learn More

Request a Demo
Services
Managed Detection & Response

Eliminate active threats with 24/7 threat detection, investigation, and response.

Co-Managed SOC (SIEM)

Maximize your SIEM investment, stop alert fatigue, and enhance your team with hybrid security operations support.

Advisory & Diagnostics

Advance your cybersecurity program and get expert guidance where you need it most.

Penetration Testing

Test your physical locations and IT infrastructure to shore up weaknesses before exploitation.

Database Security

Prevent unauthorized access and exceed compliance requirements.

Email Security

Stop email threats others miss and secure your organization against the #1 ransomware attack vector.

Digital Forensics & Incident Response

Prepare for the inevitable with 24/7 global breach response in-region and available on-site.

Firewall & Technology Management

Mitigate risk of a cyberattack with 24/7 incident and health monitoring and the latest threat intelligence.

View All Trustwave Services
Solutions
BY INDUSTRY
BY REGULATION
BY TOPIC
Microsoft Security
Unlock the full power of Microsoft Security
Offensive Security
Solutions to maximize your security ROI
Rapidly Secure New Environments
Security for rapid response situations
Securing the Cloud
Safely navigate and stay protected
Securing the IoT Landscape
Test, monitor and secure network objects
Why Trustwave
About Us
We reduce cyber risk and fortify organizations
Awards and Accolades
Recognition by analysts and media outlets
Trustwave SpiderLabs Team
Global researchers, ethical hackers, and responders
Trustwave Fusion Security Operations Platform
Unprecedented security visibility and control
Trustwave Security Colony
Access to cybersecurity threat protection resources
Partners
Technology Alliance Partners
Key alliances who align and support our ecosystem of security offerings
Trustwave PartnerOne Program
Join forces with Trustwave to protect against the most advance cybersecurity threats
Register
Login
Resources
BLOGS
UPCOMING
MEDIA & ASSETS
NOTICES
HELP
Database Security

Database Security Knowledgebase Update 5.35

December 20, 2018

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.
  • AppDetectivePRO customers can use the Updater within the product as well

 

Latest Software Updates

DbProtect 6.6.13 Now Available

Announcing DbProtect Suite Release 6.6.13 For any additional information, navigate to the Database Security folder in the File Cabinet of the Support section in the Trustwave Fusion platform. With...

Read More

DbProtect 6.6.12 and AppDetectivePRO 10.10 Now Available

Announcing DbProtect Suite Release 6.6.12 For any additional information, navigate to the Database Security folder in the File Cabinet of the Support section in the Trustwave Fusion platform.

Read More

DbProtect Suite release 6.6.11 Now Available

Announcing DbProtect Suite Release 6.6.11 We're excited to announce that with this release, we have implemented several security updates and additional checks to enhance the overall protection of...

Read More