操作系统suseLinux的openSUSE 10.2 (i586),db2数据库版本 为32位的v8.1.用db2_install安装一切挺正常,然后用实例用户linuxfe(没用db2inst1)建立实例,然后建立数据库db2sampl后测试,发现一个奇怪问题..
db2=>connect to sample 没问题,而
db2=>connect to sample user linuxfe using linuxfe就报SQL30082NAttempt to establish connection failed with security reason "24"
("USERNAME AND/OR PASSWORD INVALID"
.SQLSTATE=08001
对于linuxfe的用户和密码登陆系统是没有问题的,也反复测试过了.
我用重新建立个系统用户test
用linuxfe进入,db2=>connect to sample也只能这样连接进去了,然后
db2=>grant connect, createtab, bindadd on database to user test;
可是问题依然是这样. db2=>connect to sample 没问题, db2=>connect to sample user test using test就不行了.
真是百思不得其解.....难道是suseLinux的认证有问题?
|