6.6 Ensure ALL Events are Audited

Information

This filter defines all events to be written to the audit log.

Rationale:

This filter to log all, and binding to all, users must be set to ensure all event information is written to the audit log.

Impact:

Logging all events can result in very large audit files. In the case where the database is extremely active it may be more appropriate to be more selective when defining audit filters.

Solution

Create Log All Filter:

SELECT audit_log_filter_set_filter('log_all', '{ 'filter': { 'log': true } }');

Apply to all logins:

SELECT audit_log_filter_set_user('%', 'log_all');

See Also

https://workbench.cisecurity.org/benchmarks/12903