怎么查看ibm db2 simple数据库用户名密码

查看当前用户: select user()

查看用户的权限: show grants for 'username'@'localhost'

查看当前用户的权限: show grants

修改 root 用户的密码

set password for 'root'@'localhost' = password('新密码')

或者:

update user set password = password('newpass') where user = 'root'

flush privileges

PRIVILEGES

查看当前用户: select user()

查看用户的权限: show grants for 'username'@'localhost'

查看当前用户的权限: show grants

修改 root 用户的密码

set password for 'root'@'localhost' = password('新密码')

或者:

update user set password = password('newpass') where user = 'root'

flush privileges

PRIVILEGES

select name from sysibm.systables where type='T' and creator='DB2ADMIN'

type:数据库表用T表示；数据库视图用V表示

creator:数据库对象的创建者

---