init parameter

cra32523

于 2006-12-12 11:22:04 发布

阅读量361

点赞数

文章标签：数据库

本文介绍Oracle数据库升级过程中O7_DICTIONARY_ACCESSIBILITY参数的作用。该参数控制从Oracle7到Oracle8i及更高版本升级时对系统权限的限制。当设置为TRUE时，允许访问SYS模式下的对象；若为FALSE，则限制了对SYS模式下对象的访问。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

init parameter

[@more@]

The O7_DICTIONARY_ACCESSIBILITY initialization parameter controls restrictions on system privileges when you upgrade from Oracle7 to Oracle8i and higher releases. If the parameter is set to TRUE, access to objects in the SYS schema is allowed (Oracle7 behavior). If this parameter is set to FALSE, system privileges that allow access to objects in "any schema" do not allow access to objects in SYS schema. The default for O7_DICTIONARY_ACCESSIBILITY is FALSE.

When this parameter is not set to FALSE, the ANY privilege applies to the data dictionary, and a malicious user with ANY privilege could access or alter data dictionary tables.

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

转载于:http://blog.itpub.net/66865/viewspace-883458/