ORACLE 给用户授权SELECT_CATALOG_ROLE

最新推荐文章于 2023-12-01 09:51:26 发布

scx0110

最新推荐文章于 2023-12-01 09:51:26 发布

阅读量5.4k

点赞数 1

分类专栏：数据库文章标签： Oracle ORACLE DBA

本文链接：https://blog.csdn.net/u014231534/article/details/107196897

版权

数据库专栏收录该内容

7 篇文章

订阅专栏

先说重点，GRANT SELECT_CATALOG_ROLE TO 用户名;

等同于

SELECT on TABLE SYS.ARGUMENT$
SELECT on VIEW SYS.DBA_COL_COMMENTS
SELECT on VIEW SYS.DBA_CONS_COLUMNS
SELECT on VIEW SYS.DBA_CONSTRAINTS
SELECT on VIEW SYS.DBA_IND_COLUMNS
SELECT on VIEW SYS.DBA_INDEXES
SELECT on VIEW SYS.DBA_JOBS
SELECT on VIEW SYS.DBA_OBJECTS
SELECT on VIEW SYS.DBA_PROFILES
SELECT on VIEW SYS.DBA_ROLE_PRIVS
SELECT on VIEW SYS.DBA_SEQUENCES
SELECT on VIEW SYS.DBA_SYNONYMS
SELECT on VIEW SYS.DBA_TAB_COLUMNS
SELECT on VIEW SYS.DBA_TAB_COMMENTS
SELECT on VIEW SYS.DBA_TABLES
SELECT on VIEW SYS.DBA_TRIGGERS
SELECT on VIEW SYS.DBA_USERS
EXECUTE on PACKAGE SYS.DBMS_LOCK
EXECUTE on PACKAGE BODY SYS.DBMS_LOCK
EXECUTE on PACKAGE SYS.DBMS_OBFUSCATION_TOOLKIT
EXECUTE on PACKAGE BODY SYS.DBMS_OBFUSCATION_TOOLKIT
SELECT on TABLE SYS.JOB$
SELECT on TABLE SYS.OBJ$
SELECT on TABLE SYS.SOURCE$
SELECT on TABLE SYS.USER$
SELECT on VIEW SYS.V_$SESSION

查一个问题，有个用户并没有授权 DBA_ERRORS 表查询权限，却可以查询。后来发现是授权了SELECT_CATALOG_ROLE。