2.2.4 Ensure 'O7_DICTIONARY_ACCESSIBILITY' Is Set to 'FALSE'

Information

The O7_dictionary_accessibility setting is a database initialization parameter that allows/disallows access to objects with the ANY privileges (SELECT ANY TABLE, DELETE ANY TABLE, EXECUTE ANY PROCEDURE, etc.). This functionality was created for the ease of migration from Oracle 7 databases to later versions. The setting should have a value of FALSE.

Note: The O7_dictionary_accessibility parameter has been deprecated in 12.2 and higher versions.

Rationale:

Leaving the SYS schema so open to connection could permit unauthorized access to critical data structures.

Solution

To remediate this setting, execute the following SQL statement.

ALTER SYSTEM SET O7_DICTIONARY_ACCESSIBILITY=FALSE SCOPE = SPFILE;

See Also

https://workbench.cisecurity.org/files/2868