DB2无法使用新用户连接到数据库

本文介绍了DB2无法使用新用户连接到数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 我已经创建了一个DB2数据库，我正在尝试创建一个新的用户。 这里我做的步骤： - 使用root帐户（useradd myuser）创建一个操作系统（Linux）用户 - 给新用户（passwd myuser）提供密码 - 在IBM Data Studio中，我添加了一个新用户并授予他连接到数据库

但是在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.