DB2 Routine "*RATE_DDL" SQLCODE=-443, SQLSTATE=38553, DRIVER=4.26.14

使用DBeaver连接DB2数据库，发现用户查看表DDL语句时报错：

具体报错内容：SQL 错误 [38553]: Routine "*RATE_DDL" (specific name "*RATE_DDL") has returned an error SQLSTATE with diagnostic text "SQL0551 Reason code or token: GBDWTJ,USAGE,SYSTOOLS.DB2LOOK".. SQLCODE=-443, SQLSTATE=38553, DRIVER=4.26.14+

显示用户没有查看权限

已经给该用户赋予了表的全部权限

GRANT CONTROL ON TABLE TO USER USERNAME

但还是没有查看DDL语句的权限

搜索相关报错内容，发现IBM官网给出类似报错解决方案

附上链接：

https://www.ibm.com/docs/zh/ias?topic=troubleshooting-data-movement

https://www.ibm.com/docs/zh/ias?topic=hadoop-data-movement#c_hdp_data_movement__privileges

尝试给用户授予视图 "SYSTOOLS"."DB2LOOK_INFO"的权限后，再次通过DBeaver查看表的DDL语句，不再报错，显示出完整DDL语句

GRANT DELETE,INSERT,SELECT ON TABLE "SYSTOOLS"."DB2LOOK_INFO" TO USER "USERNAME"