3.10 Ensure No Users Are Assigned the 'DEFAULT' Profile

Information

It is recommended that users be created with function-appropriate profiles. The DEFAULT profile, being defined by Oracle, is subject to change at any time (e.g. by patch or version update). The DEFAULT profile has unlimited settings that are often required by the SYS user when patching; such unlimited settings should be tightly reserved and not applied to unnecessary users.

Solution

To remediate this recommendation execute the following SQL statement for each user returned by the audit query using a functional-appropriate profile. ALTER USER <username> PROFILE <appropriate_profile>

See Also

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