Secure connections by using trusted contexts

MediumLevel 1Manual reviewdb2-zos

Description

Trusted context provides the capability to enforce the security attributes for a connection, switch users in the connection with optional authentication, and acquire one or more privileges that are not available outside of the trusted context. It is recommended that you enable trusted context for connections that use shared IDs.

How it is checked

Audit method: Manual review

This recommendation cannot be checked automatically. A scan lists it with these instructions when you pass --include-manual.

1. Issue the following SQL statement to verify that a trusted context is enabled. SELECT NAME, CONTEXTID, SYSTEMAUTHID, DEFAULTROLE, OBJECTOWNERTYPE, ENABLED, ALLOWPUBLIC, AUTHENTICATEPUBLIC FROM SYSIBM.SYSCONTEXT; SELECT CONTEXTID, NAME, VALUE FROM SYSIBM.SYSCTXTTRUSTATTRS; SELECT CONTEXTID, AUTHID, AUTHENTICATE, ROLE FROM SYSIBM.SYSCONTEXTAUTHIDS; 2. Review the trusted context definition.

How it is fixed

Fix method: Guidance or infrastructure patch

Create and enable trusted contexts based on the rules of your organization.

Properties

Operating systems: Any
Tags: db2-zoshardening
Reference: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.1.6 Secure connections by using trusted contexts