问题:
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]

这个是因为这个数据库版本没有SELECT_CATALOG_ROLE这个角色,这个版本的话只能通过授予DBA角色来解决,如果升级到当前新的版本,可以通过执行sp_upgrade_select_catalog_role及GRANT SELECT_CATALOG_ROLE TO "BIGDATA-READONLY";处理这个问题