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;