System Privileges must not be granted to PUBLIC.
Overview
| Finding ID | Version | Rule ID | IA Controls | Severity |
| V-270528 | O19C-00-009600 | SV-270528r1064862_rule | CCI-000366 | medium |
| Description | ||||
| System privileges can be granted to users and roles and to the user group PUBLIC. All privileges granted to PUBLIC are accessible to every user in the database. Many of these privileges convey considerable authority over the database and should be granted only to those persons responsible for administering the database. In general, these privileges should be granted to roles and then the appropriate roles should be granted to users. System privileges must never be granted to PUBLIC as this could allow users to compromise the database. | ||||
| 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-270528r1064862_chk)
From SQL*Plus:
Select privilege from dba_sys_privs where grantee = 'PUBLIC';
If any records are returned, this is a finding.
Fix Text (F-74462r1064861_fix)
Revoke any system privileges assigned to PUBLIC:
From SQL*Plus:
revoke [system privilege] from PUBLIC;
Replace [system privilege] with the named system privilege.
Note: System privileges are not granted to PUBLIC by default and would indicate a custom action.