ITPub博客

首页 > Linux操作系统 > Linux操作系统 > O7_DICTIONARY_ACCESSIBILITY(转)

O7_DICTIONARY_ACCESSIBILITY(转)

原创 Linux操作系统 作者:tochar 时间:2007-07-27 00:00:00 0 删除 编辑

O7_DICTIONARY_ACCESSIBILITY

Parameter type

Boolean

Default value

false

Parameter class

Static

Range of values

true | false

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.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9078678/viewspace-45125/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-11

  • 博文量
    118
  • 访问量
    787014