Ensure Audit Filters Capture Connection Attempts

SrednjaNivo 1Ručni pregledoceanbase

Opis

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.

Kako se proverava

Metod provere: Ručni pregled

Ova preporuka se ne može proveriti automatski. Skeniranje je navodi sa ovim uputstvima kada prosledite --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.

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

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.

Svojstva

Operativni sistemi: Bilo koji
Oznake: oceanbaseloggingaudit
Referenca: CIS OceanBase Enterprise Edition V4 Benchmark v1.0.0 - 4.4.2 Ensure Audit Filters Capture Connection Attempts