--权限相关的视图
db2 "select substr(tabname,1,30) as tabname
from syscat.tables
where tabschema='SYSCAT' and tabname like '%AUTH'
"
--查看数据库用户
db2 " select char(authid,30) as authid, authidtype
from sysibmadm.authorizationids
"
--查看public的数据库权限
db2 "select substr(grantee,1,32) as grantee,granteetype,
bindaddauth,dbadmauth,connectauth,createtabauth,implschemaauth,loadauth,dataaccessauth
from syscat.dbauth
where grantee='PUBLIC'
"
<
db2 "select substr(tabname,1,30) as tabname
from syscat.tables
where tabschema='SYSCAT' and tabname like '%AUTH'
"
--查看数据库用户
db2 " select char(authid,30) as authid, authidtype
from sysibmadm.authorizationids
"
--查看public的数据库权限
db2 "select substr(grantee,1,32) as grantee,granteetype,
bindaddauth,dbadmauth,connectauth,createtabauth,implschemaauth,loadauth,dataaccessauth
from syscat.dbauth
where grantee='PUBLIC'
"
<