但是在Linux上,拥有该实例的用户,我尝试连接到数据库与新用户(db2连接到MYDB用户myuser),我有以下: SQL30082N安全处理失败,原因24(USERNAME AND / OR PASSWORD INVALID)。 SQLSTATE = 08001
我做错了?
提前感谢您的帮助
解决方案答案可能取决于DB2版本。直到DB2 9.7修复包1,您的密码不能超过8个字符。实际用户名多长时间?我也会把它限制在8个字符。错误很清楚:用户身份验证失败,而DB2依赖于操作系统进行身份验证。
I have created a DB2 database, and I'm trying to create a new user. Here the steps I made : - Creating an OS (Linux) user with root account (useradd myuser) - Giving a password to the new user (passwd myuser) - On IBM Data Studio, I added a new user and grant him connect to the database
But on Linux, with the user which owns the instance, I tried to connect to the database with the new user (db2 connect to MYDB user myuser), I've the following : SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
Am I doing something wrong ?
Thanks in advance for your help
解决方案The answer might depend on the DB2 version. Until DB2 9.7 fix pack 1 you could not have the password longer than 8 characters. And how long is the actual user name? I would limit that to 8 characters as well. The error is quite clear: the user authentication fails, and DB2 relies on the OS for authentication.
更多推荐
DB2无法使用新用户连接到数据库
发布评论