Hello

I am using DB2 V8.1 ( no fixpak) on AIX 5.1. So far, I have been using the instance owner for the various operations on the databases belonging to that instance.

However, when I grant ( by connecting to the db as instance owner and then issuing the command GRANT DBADM on DATABASE to user YYY) DBADM authority to an OS user and then try connecting to the db using this user it returns me SQL30082N with reason code 24 ( Invalid userid/password). However, I am able to logon to the OS using the same user and password.

I am trying to connect to the db from the server itself.

Any ideas where the problem is ?

What sort of authentication is it ?

CLIENT/SERVER ?

Cheers
Sathyaram

Following are the dbm config parameters :-


Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Use SNA authentication (USE_SNA_AUTH) = NO
Bypass federated authentication (FED_NOAUTH) = NO

I have got it to work , but this baffles me.

Previously I was logging on as the new user onto the OS and then issuing the following command :-

CONNECT to DB user AAA using BBB.
This was returning me the error msg.

However, now when I only say CONNECT to DB it connects.

And when I connect to the db as the instance owner using CONNECT to DB user instanceowner using password it works.

Can someone please explain to me this scenario ?

When you say,

connect to db

db2 does not go to the OS and ask for password authentication
whereas, for
connect to d user user1 using passw

db2 asks the os to verify the uuid/password

Since, your instance owner works with the uid/pwd, seems that the system is in shape ... Verfiy the properties of the 'problematic' user

HTH

Sathyaram

But the userid works while logging me on to the OS. What else can be wrong ?