1. 连接数据库：db2
connect to study
2. 查询当前用户模式：select
current schema from sysibm.sysdummy1 或 select current schema
from sysibm.dual
3. 切换用户模式：set
current schema toms
4. 切换用户： db2 connect to cpsdb user Administrator using 111111
5. 给其他用户授权：db2
grant dbadm on database to user odsuser
6. 查看当前用户的权限： db2
get authorizations
{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.xiaopingtou.cn//data/attach/topic/topicKPo7gB.jpg', '推荐 来自火星的猴哥 的文章《DB2如何查看当前用户模式》','https://www.xiaopingtou.net/article-58357.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}