1. 連接數(shù)據(jù)庫(kù):db2 connect to study
2. 查詢(xún)當(dāng)前用戶(hù)模式:select current schema from sysibm.sysdummy1 或 select current schema from sysibm.dual
3. 切換用戶(hù)模式:set current schema toms
4. 切換用戶(hù): db2 connect to cpsdb user Administrator using 111111
5. 給其他用戶(hù)授權(quán):db2 grant dbadm on database to user odsuser
6. 查看當(dāng)前用戶(hù)的權(quán)限: db2 get authorizations
更多信息請(qǐng)查看IT技術(shù)專(zhuān)欄