Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 127 of 220
Parameter type |
Boolean |
Default value |
|
Parameter class |
Static |
Range of values |
|
O7_DICTIONARY_ACCESSIBILITY
is intended for use when you migrate from Oracle7 to Oracle9i. It controls restrictions on SYSTEM
privileges. If the parameter is set to true
, access to objects in the SYS
schema is allowed (Oracle7 behavior). The default setting of false
ensures that system privileges that allow access to objects in "any schema" do not allow access to objects in SYS
schema.
For example, if O7_DICTIONARY_ACCESSIBILITY = 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). 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 privilege. Also, the following roles, which can be granted to the database administrator, also allow access to dictionary objects: SELECT_CATALOG_ROLE
, EXECUTE_CATALOG_ROLE
, and DELETE_CATALOG_ROLE
.
See Also:
|
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|