4.1.13 Ensure a Secure Connect Procedure is Used (CONNECT_PROC)

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

The CONNECT_PROC stored procedure runs as part of every connection to the database and allows customization of the application environment, such as setting special registers. It could for example, set the CURRENT_PATH special register which controls the search path for finding functions and procedures to execute. Only an authorized procedure should be used.

Rationale:

The CONNECT_PROC procedure could be used to modify the application environment within the connection causing unexpected behavior.

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

Solution

To turn off the connect proc, perform the following commands:

Connect to the Db2 database

db2 => connect to <dbname>

Run the following command:

db2 => update database configuration using
connect_proc NULL IMMEDIATE

See Also

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