SV-261872r1000621_rule
V-261872
SRG-APP-000101-DB-000044
CD16-00-001600
CAT II
10
Configure PostgreSQL audit settings to include all organization-defined detailed information in the audit records for audit events identified by type, location, or subject.
Using pgaudit, PostgreSQL can be configured to audit these requests. Refer to supplementary content APPENDIX-B for documentation on installing pgaudit.
To ensure logging is enabled, see the instructions in the supplementary content APPENDIX-C.
Note: The following instructions use the PGDATA and PGLOG environment variables. Refer to APPENDIX-F and APPENDIX-I for instructions on configuring them.
Review the system documentation to identify what additional information the organization has determined necessary.
Check PostgreSQL settings by examining ${PGDATA?}/postgresql.conf to ensure additional auditing is configured and then examine existing audit records in ${PGLOG?}/<latest.log> to verify that all organization-defined additional, more detailed information is in the audit records for audit events identified by type, location, or subject after executing SQL commands that fall under the additional audit classes.
If any additional information is defined and is not contained in the audit records, this is a finding.
V-261872
False
CD16-00-001600
Note: The following instructions use the PGDATA and PGLOG environment variables. Refer to APPENDIX-F and APPENDIX-I for instructions on configuring them.
Review the system documentation to identify what additional information the organization has determined necessary.
Check PostgreSQL settings by examining ${PGDATA?}/postgresql.conf to ensure additional auditing is configured and then examine existing audit records in ${PGLOG?}/<latest.log> to verify that all organization-defined additional, more detailed information is in the audit records for audit events identified by type, location, or subject after executing SQL commands that fall under the additional audit classes.
If any additional information is defined and is not contained in the audit records, this is a finding.
M
5598