Ensure that access to dynamic query-related tables is restricted

보통레벨 1수동 검토db2-zos

설명

The following tables contain information related to the stabilization of access paths for dynamic SQL statements and dependencies for dynamic query packages: SYSIBM.SYSDYNQRY SYSIBM.SYSDYNQRYDEP SYSIBM.SYSDYNQRY_TXTL PUBLIC should be restricted from accessing these tables. Exposing dynamic SQL statements and dynamic queries can enable attackers to gain access to your organization's data.

점검 방법

감사 방식: 수동 검토

이 권장 사항은 자동으로 점검할 수 없습니다. --include-manual 옵션을 전달하면 스캔 결과에 이 지침과 함께 표시됩니다.

For Db2 internal security users: Issue the following SQL statement to check if PUBLIC has access: SELECT GRANTEE, TCREATOR, TTNAME FROM SYSIBM.SYSTABAUTH WHERE TCREATOR = 'SYSIBM' AND TTNAME IN ('SYSDYNQRY', 'SYSDYNQRYDEP', 'SYSDYNQRY_TXTL') AND GRANTEE = 'PUBLIC'; Output that contains zero rows is considered a successful finding. Otherwise, PUBLIC has SELECT privilege and the remediation steps should be followed. For external security users: Issue the RACF RLIST command to list the profiles that control access to the dynamic query-related tables in the ... (full steps: CIS section 2.2.9)

조치 방법

조치 방식: 가이드 또는 인프라 패치

For Db2 internal security users: Issue the SQL REVOKE statement to revoke access from PUBLIC. For external security users: Issue the RACF RALTER command to update the profiles and change the UACC setting to NONE. Issue the RACF PERMIT command to remove the ID(*) and specify users or groups.

속성

운영 체제: 모두
태그: db2-zospermissions
참고 자료: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.9 Ensure that access to dynamic query-related tables is restricted