O7_Dictionary_Accessibility
设为TRUE时,以sys登录,可以不用加as sysdba,可以创建dblink用sys用户连接
select any dictionary可以override O7_DICTIONARY_ACCESSIBILITY=false访问系统数据字典
设为TRUE时,以sys登录,可以不用加as sysdba,可以创建dblink用sys用户连接
select any dictionary可以override O7_DICTIONARY_ACCESSIBILITY=false访问系统数据字典
几个主要的相关角色和权限:
SELECT ANY TABLE
SELECT_CATALOG_ROLE
SELECT ANY DICTIONARY
SELECT ANY TABLE
SELECT_CATALOG_ROLE
SELECT ANY DICTIONARY
SELECT_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
参考文档:
What is O7_DICTIONARY_ACCESSIBILITY and how Should it be set? [ID 206795.1]
Use SELECT ANY DICTIONARY or SELECT_CATALOG_ROLE or O7_DICTIONARY_ACCESSIBILITY? [ID 153510.1]
Use SELECT ANY DICTIONARY or SELECT_CATALOG_ROLE or O7_DICTIONARY_ACCESSIBILITY? [ID 153510.1]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/756652/viewspace-712403/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/756652/viewspace-712403/