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 scheme <scheme name> restrict

See Also

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

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b.

Plugin: IBM_DB2DB

Control ID: 8666c3470a30a6992cb85d05807c15745d836028c4198a8244d9e0d3cbedadd3