UCF STIG Viewer Logo

Application role permissions must not be assigned to the Oracle PUBLIC role.


Overview

Finding ID Version Rule ID IA Controls Severity
V-61443 O121-BP-022800 SV-75933r1_rule Medium
Description
Permissions granted to PUBLIC are granted to all users of the database. Custom roles must be used to assign application permissions to functional groups of application users. The installation of Oracle does not assign role permissions to PUBLIC.
STIG Date
Oracle Database 12c Security Technical Implementation Guide 2017-06-30

Details

Check Text ( C-62333r1_chk )
From SQL*Plus:

select granted_role from dba_role_privs where grantee = 'PUBLIC';

If any roles are listed, this is a finding.
Fix Text (F-67359r1_fix)
Revoke role grants from PUBLIC.

Do not assign role privileges to PUBLIC.

From SQL*Plus:

revoke [role name] from PUBLIC;