• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3155
  • Last Modified:

DB2 User Access denied

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
          Password:
          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

0
1981m
Asked:
1981m
  • 2
  • 2
1 Solution
 
momi_sabagCommented:
which os is this ?
what do you mean by "Add an new OS ID "brokernet" successfully" ?
are you sure it's password is brokernet ?
0
 
1981mAuthor Commented:
yep I am sure the pwd is same as the user name.
0
 
momi_sabagCommented:
are you connecting from the server or from a client on a different machine ?
if the client is on a different machine you need to make sure you created the user on the server machine
0
 
1981mAuthor Commented:
I created it on the server and the OS is RHEL 4.x.
I trying to connect from the client  to the server.
0
 
prmurphy63026Commented:
So is the new userid in DB2's administrator group?

Use  /u to specify the account name and password for the DB2 service.
This option is required when creating a partitioned database
instance.

I'm believe this will make the userID the instance owner.  As the instance owner you are 'God'.

In this command:
db2 attach to db2inst1user brokernet using brokernet new brokernet confirm brokernet

it appears there is a missing space between 'db2inst1' and 'user'. I assume that was a typo.

I would recommend setting the password at the OS level and not within the login and confirm the password change by giving the UID login privileges and logging in.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now