Application role permissions must not be assigned to the Oracle PUBLIC role.
Overview
| Finding ID | Version | Rule ID | IA Controls | Severity |
| V-270532 | O19C-00-010000 | SV-270532r1064874_rule | CCI-000366 | 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 19c Security Technical Implementation Guide | 2025-06-24 | |||
Related Frameworks
4 paths across 3 frameworks
Related Frameworks
NIST 800-531 mapping
CM-6
1.00
- DISA · 1 · disa_xccdf · related
- DISA · 2025-01-23 · disa_cci_list · equivalent
NIST 800-1712 mappings
3.4.1
1.00
- DISA · 1 · disa_xccdf · related
- DISA · 2025-01-23 · disa_cci_list · equivalent
- NIST · Rev 2 (Feb 2020, errata Jan 2021) · nist_800_171_app_d · equivalent
3.4.2
1.00
- DISA · 1 · disa_xccdf · related
- DISA · 2025-01-23 · disa_cci_list · equivalent
- NIST · Rev 2 (Feb 2020, errata Jan 2021) · nist_800_171_app_d · equivalent
CCI1 mapping
CCI-000366
1.00
- DISA · 1 · disa_xccdf · related
Details
Check Text (C-270532r1064874_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-74466r1064873_fix)
Revoke role grants from PUBLIC.
Do not assign role privileges to PUBLIC.
From SQL*Plus:
revoke [role name] from PUBLIC;