9.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.

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

Solution

Remote unnecessary schemas.
1. Connect to the DB2 database.
db2 => connect to $DB2DATABASE user $USERNAME using $PASSWORD
2. Run the following command from the DB2 command window-
db2 => drop scheme <scheme name> restrict
3. Review unused schemas and remove if necessary

See Also

https://workbench.cisecurity.org/files/162

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b., CSCv6|9.1

Plugin: IBM_DB2DB

Control ID: 51327338c5b6140425399abb8d1655e2516624910370308b554f81c65bb92eb6