db2 监控用户授权

最新推荐文章于 2022-05-20 18:38:32 发布

hbhe0316

最新推荐文章于 2022-05-20 18:38:32 发布

阅读量1.2k

点赞数

文章标签： python java linux 大数据 javascript

本文链接：https://blog.csdn.net/hbhe0316/article/details/122701594

版权

在创建db2后面跟RESTRICTIVE参数后，如果需要创建监控用户，那么需要给监控用户授权，以db2 11.1.4.5为例授权如下。https://www.cndba.cn/hbhe0316/article/4785https://www.cndba.cn/hbhe0316/article/4785https://www.cndba.cn/hbhe0316/article/4785https://www.cndba.cn/hbhe0316/article/4785

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

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

db2 "create db <dbname> on /db2data1, /db2data2 ...... dbpath on /<db2path> using codeset utf-8 territory CN RESTRICTIVE"
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"

Linux,oracle