STIGUI
V-219839CAT II — Medium severitySV-219839r961863_rule

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

Rule version O121-BP-022800 · STIG v3 · 2025-02-12

Discussion

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.

Check

From SQL*Plus:

select granted_role from dba_role_privs where grantee = 'PUBLIC';

If any roles are listed, this is a finding.

Fix

Revoke role grants from PUBLIC.

Do not assign role privileges to PUBLIC.

From SQL*Plus:

revoke [role name] from PUBLIC;

Identifiers

Group ID
V-219839
Group title
SRG-APP-000516-DB-000363
Rule ID
SV-219839r961863_rule
Check ID
C-21550r533056_chk
Fix ID
F-21549r533057_fix