5.6 Enable 'PROFILE' Audit Option

Information

As profiles are part of the database security infrastructure, auditing the modification of profiles is recommended.

Solution

Execute the following SQL statement to remediate this setting. AUDIT PROFILE; Impact: The statement auditing option 'audit PROFILE' audits everything that the three privilege audits 'audit CREATE PROFILE', 'audit DROP PROFILE' and 'audit ALTER PROFILE' do, but also audits: 1) Attempts to create a profile by a user without the CREATE PROFILE system privilege. 2) Attempts to drop a profile by a user without the DROP PROFILE system privilege 3) Attempts to alter a profile by a user without the ALTER PROFILE system privilege.

See Also

https://workbench.cisecurity.org/files/601

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-12c.

Plugin: OracleDB

Control ID: 75129c936f4255a7f08f6a35b09c7796e8e3330bec245adc496cb0416fa8e750