DB2 表对象权限异常

应用执行权限命令后抛出异常：
1 问题现象https://www.cndba.cn/hbhe0316/article/4892

SQL0551N “GFRONT” does not hava the requirement authorization or privilege to perform operation “SELECT” on object “GFRONT.TBL_ACCMLT_AMTS”.SQLSTAT=42501

2 问题诊断
GFRONT模式没有对GFRONT.TBL_ACCMLT_AMTS具有SELECT权限。https://www.cndba.cn/hbhe0316/article/4892https://www.cndba.cn/hbhe0316/article/4892https://www.cndba.cn/hbhe0316/article/4892

3 恢复步骤

https://www.cndba.cn/hbhe0316/article/4892

https://www.cndba.cn/hbhe0316/article/4892

https://www.cndba.cn/hbhe0316/article/4892

https://www.cndba.cn/hbhe0316/article/4892

https://www.cndba.cn/hbhe0316/article/4892

https://www.cndba.cn/hbhe0316/article/4892

su - <instname>
db2 connect to <dbname>
db2 “grant select on table GFRONT.TBL_ACCMLT_AMTS to user GFRONT”
db2 terminate

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2