Detections
Analytics

1.38 O19C-00-010000

Information

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

GROUP ID: V-270532
RULE ID: SV-270532r1064874

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.

Solution

Revoke role grants from PUBLIC.

Do not assign role privileges to PUBLIC.

From SQL*Plus:

revoke [role name] from PUBLIC;

See Also

https://workbench.cisecurity.org/benchmarks/26166

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b., CAT|II, CCI|CCI-000366, Rule-ID|SV-270532r1064874_rule, STIG-ID|O19C-00-010000, Vuln-ID|V-270532

Plugin: OracleDB

Control ID: 2baab146afe1867601acf8cb3dbc7ce5bc551b4daa4e3b38cf8a2c9e248b8d12