DB2 User Access denied
Posted on 2007-11-19
Hi DB2 experts , I have a problem in a user accessing database?
This is a DB2 V9.1 problem for attaching the new Brokernet user id to db2instance and database.
Here is what I did:
1) Add an new OS ID "brokernet" successfully.
2) Update the instance: db2inst1 with the new ID "brokernet" successfully.
[db2adm@de-kpbwp-ldb03 instance]$ sudo ./db2iupdt db2inst1 /u:brokernet,brokernet
DBI1070I Program db2iupdt completed successfully.
3) Authenticate the new ID "brokernet" to DB2 instance failed.
[db2inst1@de-kpbwp-ldb03 ~]$ db2 attach to db2inst1user brokernet using brokernet new brokernet confirm brokernet
SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR
PASSWORD INVALID"). SQLSTATE=08001