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]