STIGQter: STIG Summary: IBM DB2 V10.5 LUW Security Technical Implementation Guide Version: 1 Release: 4 Benchmark Date: 25 Oct 2019:

DB2 must prohibit user installation of logic modules (stored procedures, functions, triggers, views, etc.) without explicit privileged status.

DISA Rule

SV-89263r1_rule

Vulnerability Number

V-74589

Group Title

SRG-APP-000378-DB-000365

Rule Version

DB2X-00-008000

Severity

CAT II

CCI(s)

• CCI-001812 - The information system prohibits user installation of software without explicit privileged status.

Weight

10

Fix Recommendation

Run the REVOKE command to revoke database authorities and schema privileges from user:
DB2> REVOKE CREATEIN ON SCHEMA<schema_name> FROM <user>
DB2> REVOKE <db authority> ON DATABASE FROM <USER>

Note: Select the following knowledgebase link for information regarding revoking database authorities:
http://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000981.html?cp=SSEPGG_10.5.0%2F2-12-7-181&lang=en

Select the following knowledgebase link for information regarding revoking schema privileges:
http://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000988.html?cp=SSEPGG_10.5.0%2F2-12-7-189&lang=en

Check Contents

The user needs CREATEINAUTH privileges for the schema to create objects in an existing schema.

Run the following Query to find which user has privilege to create objects in schemas:
DB2> SELECT GRANTEE, SCHEMANAME, CREATEINAUTH, ALTERINAUTH
FROM SYSCAT.SCHEMAAUTH

If a non-authorized user has privilege, this is a finding.

Run the following query to which user has privilege to create new schema and other objects:
DB2> SELECT GRANTEE, CREATETABAUTH, EXTERNALROUTINEAUTH, DBADMAUTH, IMPLSCHEMAAUTH
FROM SYSCAT.DBAUTH

If a non-authorized user has privilege, this is a finding.

Vulnerability Number

V-74589

Documentable

False

Rule Version

DB2X-00-008000

Severity Override Guidance

The user needs CREATEINAUTH privileges for the schema to create objects in an existing schema.

Run the following Query to find which user has privilege to create objects in schemas:
DB2> SELECT GRANTEE, SCHEMANAME, CREATEINAUTH, ALTERINAUTH
FROM SYSCAT.SCHEMAAUTH

If a non-authorized user has privilege, this is a finding.

Run the following query to which user has privilege to create new schema and other objects:
DB2> SELECT GRANTEE, CREATETABAUTH, EXTERNALROUTINEAUTH, DBADMAUTH, IMPLSCHEMAAUTH
FROM SYSCAT.DBAUTH

If a non-authorized user has privilege, this is a finding.

Check Content Reference

M

Target Key

3161

Comments