DB2无法使用新用户连接到数据库 [英] DB2 Can't connect to db with new user

问题描述

我已经创建了一个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.

这篇关于DB2无法使用新用户连接到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！