Detections
Analytics

4.5.2 Remove Unused Schemas

Information

A schema is a logical grouping of database objects. It is recommended that unused schemas be removed from the database.

Rationale:

Unused schemas can be left unmonitored and may be subjected to abuse and therefore should be removed.

NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.

Solution

Remove unnecessary schemas.

Connect to the Db2 database.

db2 => connect to <dbname>

Run the following command:

db2 => drop schema <schema name> restrict

See Also

https://workbench.cisecurity.org/benchmarks/23492

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b.

Plugin: IBM_DB2DB

Control ID: a527769e6d14643c38aab0f59acde0f1d1ea764702cec6a23fae217cee8e33b2