1.215 O7_DICTIONARY_ACCESSIBILITY
O7_DICTIONARY_ACCESSIBILITY
controls restrictions on SYSTEM
privileges.
Property | Description |
---|---|
Parameter type |
Boolean |
Default value |
|
Modifiable |
No |
Modifiable in a PDB |
Yes |
Range of values |
|
Basic |
No |
If the parameter is set to true
, access to objects in the SYS
schema is allowed (Oracle7 behavior). The false
setting ensures that system privileges that allow access to objects in "any schema" do not allow access to objects in the SYS
schema.
For example, if O7_DICTIONARY_ACCESSIBILITY
is set to false
, then the SELECT ANY TABLE
privilege allows access to views or tables in any schema except the SYS
schema (data dictionary tables cannot be accessed). If O7_DICTIONARY_ACCESSIBILITY is set to false
, then to access objects in the SYS
schema, the user should have SELECT ANY DICTIONARY
system privilege or the user should have been granted SELECT
object privilege on the specific objects. The system privilege EXECUTE ANY PROCEDURE
allows access on the procedures in any schema except the SYS
schema.
If this parameter is set to false
and you need to access objects in the SYS
schema, then you must be granted explicit object privileges. The following roles, which can be granted to the database administrator, also allow access to dictionary objects:
-
SELECT_CATALOG_ROLE
-
EXECUTE_CATALOG_ROLE
Note:
The O7_DICTIONARY_ACCESSIBILITY
initialization parameter is deprecated in Oracle Database 12c Release 2 (12.2.0.1), and may be desupported in a future release.
See Also:
-
Oracle Database SQL Language Reference for information on granting roles
-
Oracle Database Security Guide for more information about enabling data dictionary protection using this parameter