Application role permissions must not be assigned to the Oracle PUBLIC role.
An XCCDF Rule
Description
<VulnDiscussion>Application roles have been granted to PUBLIC. Permissions granted to PUBLIC are granted to all users of the database. Custom roles should be used to assign application permissions to functional groups of application users. The installation of Oracle does not assign role permissions to PUBLIC.</VulnDiscussion><FalsePositives></FalsePositives><FalseNegatives></FalseNegatives><Documentable>false</Documentable><Mitigations></Mitigations><SeverityOverrideGuidance></SeverityOverrideGuidance><PotentialImpacts></PotentialImpacts><ThirdPartyTools></ThirdPartyTools><MitigationControl></MitigationControl><Responsibility></Responsibility><IAControls></IAControls>
- ID
- SV-219711r879887_rule
- Severity
- Medium
- References
- Updated
Remediation - Manual Procedure
Revoke role grants from PUBLIC.
Do not assign role privileges to PUBLIC.
From SQL*Plus: