SEO

#1 (**permalink**) 02-27-2008, 02:29 AM

Hello,
I had a strange situation with a DB2 access.
The db2 is set with "server authentication" type.
I don't know the reason but I was in front of the following situation
:
The user ID used to connect to the DB2 on a Solaris have a well
defined password.
If I try to connect to the DB as this user and with the "good"
password, the access is refused.
Same case if I give a wrong password. In this case it is what I
expected.
The username/password is 100% correct. I can log in on to the Unix
server with.
But what it more strange is if I give a "blank" password, just type
return to the password prompt, I'm connected to the DB.

Of course it is a special situation.
I can not find the reason of this comportment.

I re-install all the DB and now it is correct.
But what can be wrong ?

Thank a lot for any advices

#2 (**permalink**) 02-27-2008, 02:34 AM

Hi,
I think you have lost the SUID and GUID bits on the modules in
.../sqllib/adm.
Some of them are responsible for the authentification.

"Kona" <kona_iron@yahoo.fr> schrieb im Newsbeitrag
news:a1de658a.0412170036.5de8f9b9@posting.google.c om...
> Hello,
> I had a strange situation with a DB2 access.
> The db2 is set with "server authentication" type.
> I don't know the reason but I was in front of the following situation
> :
> The user ID used to connect to the DB2 on a Solaris have a well
> defined password.
> If I try to connect to the DB as this user and with the "good"
> password, the access is refused.
> Same case if I give a wrong password. In this case it is what I
> expected.
> The username/password is 100% correct. I can log in on to the Unix
> server with.
> But what it more strange is if I give a "blank" password, just type
> return to the password prompt, I'm connected to the DB.
>
> Of course it is a special situation.
> I can not find the reason of this comportment.
>
> I re-install all the DB and now it is correct.
> But what can be wrong ?
>
> Thank a lot for any advices

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DB2 authentication : how it works ?