Ensure Audit Filters Capture Connection Attempts

보통레벨 1수동 검토oceanbase

설명

The functions audit_log_filter_set_filter and audit_log_filter_set_user are used to define audit rules, which can audit both successful and failed connection events and write them to the audit log file.

점검 방법

감사 방식: 수동 검토

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

Run SHOW PARAMETERS LIKE 'audit_trail'; (must not be None). Then review SELECT * FROM oceanbase.__all_tenant_security_audit_record ORDER BY gmt_create DESC LIMIT 20; and/or SELECT * FROM oceanbase.__all_tenant_user_failed_login_stat LIMIT 20; Connection and authentication attempts, including failures, must appear in the audit records; otherwise this is a finding.

조치 방법

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

For OceanBase 4.2.4 and later: SELECT AUDIT_LOG_FILTER_SET_FILTER( 'conn_attempt_filter', '{ "filter": { "log": true, "class": [ { "name": "connection" } ] } }' ); SELECT AUDIT_LOG_FILTER_SET_USER('test_user', 'conn_attempt_filter'); For versions earlier than 4.2.4: The above functions are not supported. Use the auditing features available in that version to capture successful and failed connection attempts.

속성

운영 체제: 모두
태그: oceanbaseloggingaudit
참고 자료: CIS OceanBase Enterprise Edition V4 Benchmark v1.0.0 - 4.4.2 Ensure Audit Filters Capture Connection Attempts