签到成功

知道了

CNDBA社区CNDBA社区

appmon用户授权导入表权限

2022-01-04 22:50 1222 0 原创 DB2
作者: hbhe0316
db2 "grant usage on workload sysdefaultuserworkload to user appmon"
db2 "grant all on table <tabname> to user appmon"
db2 "grant execute on package NULLID.SQLUAO20 to appmon"
db2 "grant execute on package NULLID.SQLUFO17 to appmon"
db2 "grant execute on package NULLID.SQLUOO01 to appmon"
db2 "grant execute on package NULLID.SQLUKO0C to appmon"
db2 "grant execute on package NULLID.SQLUCO09 to appmon"
db2 "grant execute on package NULLID.SQLUBO05 to appmon"
db2 "grant execute on package NULLID.SQLUHO0B to user appmon"
db2 "grant execute on package NULLID.SQLC2O29 to appmon"
db2 "grant execute on package NULLID.SQLUPO00 to user appmon"
db2 "grant select on table syscat.functions to user appmon"
db2 "grant select on table SYSCAT.PACKAGES to user appmon"
db2 "grant select on table SYSIBMADM.DBCFG to user appmon"
db2 "grant select on table SYSCAT.INDEXCOLUSE to user appmon"
db2 "grant select on table SYSCAT.INDEXES to user appmon"
db2 "grant select on table SYSCAT.COLUMNS to user appmon"
db2 "grant select on table SYSIBM.SYSCOLUMNS to user appmon"
db2 "grant execute on function SYSPROC.BASE_TABLE to user appmon"
http://www.cndba.cn/hbhe0316/article/103905
http://www.cndba.cn/hbhe0316/article/103905
http://www.cndba.cn/hbhe0316/article/103905
http://www.cndba.cn/hbhe0316/article/103905
http://www.cndba.cn/hbhe0316/article/103905
http://www.cndba.cn/hbhe0316/article/103905 http://www.cndba.cn/hbhe0316/article/103905 http://www.cndba.cn/hbhe0316/article/103905 http://www.cndba.cn/hbhe0316/article/103905 http://www.cndba.cn/hbhe0316/article/103905

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

DB2

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
hbhe0316

hbhe0316

关注

1.只有承认无知,才能装下新的东西; 2.进步来自一点点滴滴的积累; 3.广博让你更优秀,而专业让你无法替代; 4.挫折和失败能够转换为一种财富。

  • 889
    原创
  • 1
    翻译
  • 13
    转载
  • 24
    评论
  • 访问:1140932次
  • 积分:1523
  • 等级:核心会员
  • 排名:第6名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ