注册

dbms_metadata.get_ddl获取其他用户对象ddl报错权限不足问题,尝试2种方法以及授权均无效求助,谢谢。

WWfdje 2026/10/29 267 1

问题:
SQL> select dbms_metadata.get_ddl('CONSTRAINT','C1','TEST');
select dbms_metadata.get_ddl('CONSTRAINT','C1','TEST');
[-5669]:权限不足
-5669: DBMS_METADATA.GET_DDL line 2395 .

达梦版本:
DM Database Server 64 V8
8.4
企业版
DB Version: 0x7000d
03134284368-20251110-301332-20149
Msg Version: 44
Gsu level(5) cnt: 0
授权语句:
GRANT "PUBLIC" TO "BIGDATA-READONLY";
GRANT "VTI" TO "BIGDATA-READONLY";
GRANT "SOI" TO "BIGDATA-READONLY";
GRANT EXECUTE ON "SYS"."DBMS_METADATA" TO "BIGDATA-READONLY";
GRANT SELECT TABLE TO "BIGDATA-READONLY";
GRANT SELECT ANY TABLE TO "BIGDATA-READONLY";
GRANT SELECT VIEW TO "BIGDATA-READONLY";
GRANT SELECT ANY VIEW TO "BIGDATA-READONLY";
GRANT EXECUTE ANY PROCEDURE TO "BIGDATA-READONLY";
GRANT SELECT SEQUENCE TO "BIGDATA-READONLY";
GRANT SELECT ANY SEQUENCE TO "BIGDATA-READONLY";
GRANT SELECT ANY DICTIONARY TO "BIGDATA-READONLY";
GRANT SELECT MATERIALIZED VIEW TO "BIGDATA-READONLY";
GRANT SELECT ANY MATERIALIZED VIEW TO "BIGDATA-READONLY";
GRANT CREATE SESSION TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."DBA_INDEXES" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."DBA_IND_COLUMNS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."DBA_OBJECTS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."DBA_TABLES" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."DBA_TAB_COLUMNS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_CONSTRAINTS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_OBJECTS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_COL_COMMENTS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_TAB_COMMENTS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."DBA_COL_COMMENTS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."DBA_TAB_COMMENTS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_CONS_COLUMNS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_INDEXES" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_IND_COLUMNS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_SOURCE" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_TABLES" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_TAB_COLUMNS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_VIEWS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."DBA_CONSTRAINTS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."DBA_CONS_COLUMNS" TO "BIGDATA-READONLY";
GRANT SELECT ON "SYS"."ALL_PROCEDURES" TO "BIGDATA-READONLY";
尝试1失败:
[执行语句1]
sp_upgrade_select_catalog_role();
执行失败,失败原因:
[-2207]:第1 行附近出现错误:
无法解析的成员访问表达式[sp_upgrade_select_catalog_role]

尝试2失败:
[执行语句1]
GRANT SELECT_CATALOG_ROLE TO "BIGDATA-READONLY";
执行失败,失败原因:
[-2102]:第1 行附近出现错误:
无效的角色名[SELECT_CATALOG_ROLE]

回答 0
暂无回答
扫一扫
联系客服