DB2 V8 - user account TROUBLE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xevious - 27 Jul 2005 10:51 GMT

Hi,

I am reading that db2 is using the OS for authentication. So if we run
on a Win2000 Server, I guess that we have to create user account in the
Windows2000 for every user that creates an account.

My question is:
is there a possibility to create my own db users (that will NOT exist
on my NT) and connect to db using them? How?

Thx A Lot,
Xevy

Reply to this Message

Knut Stolze - 27 Jul 2005 14:35 GMT

> Hi,
>
[quoted text clipped - 5 lines]
> is there a possibility to create my own db users (that will NOT exist
> on my NT) and connect to db using them? How?

You can define your own user exit that performs the authorization for you,
and there you can do whatever you want.

Signature

Knut Stolze
Information Integration Development
IBM Germany / University of Jena

Reply to this Message

xevious - 29 Jul 2005 10:23 GMT

Maybe I explained to myself badly and it's probable seen that I'm a DB2
neophyte.

I enter the specific one of my case.

Scenario:

* 1 Database: DBSAMPLE

* N users with N Schema (one for user) defined only and exclusively in
DB2

* N Web applications which connect one to the DB2 for user profile

* N is a number from 1 to 5

Is, with DB2V8, authenticating from WEB with one of the N users created
without these being defined as users in the operating system possible?

When I create one of the N users in the DBSAMPLE isn't asked to me to
define the password it and this, obviously, doesn't allow me to link
up.

The problem, very banally, is the itself one also from command line:

db2 > connect to DBSAMPLE USER userN
Insert password>??????????????????

A way to set up the password of the users created in the DB exists or I
must do it creating the user through the operating system?

Reply to this Message

Juliane - 29 Jul 2005 12:48 GMT

well, on LUW there is no option to create db users as you want.

But, once you have the users AND know there passwords, you can always connect
using
db2> connect to sample user username using password

you can set the authentication in the db cfg to client as well:
db2> update dbm cfg using authentication CLIENT
then they will be authorised using the client userid and password.

hope that helps

>Maybe I explained to myself badly and it's probable seen that I'm a DB2
>neophyte.
[quoted text clipped - 26 lines]
>A way to set up the password of the users created in the DB exists or I
>must do it creating the user through the operating system?

Reply to this Message

Gert van der Kooij - 29 Jul 2005 18:13 GMT

> well, on LUW there is no option to create db users as you want.

It is possible, Knut allready told to use a user exit. Check the docs
at http://tinyurl.com/b7w3d for a full description.

Kind regards, Gert

Reply to this Message

Pierre Saint-Jacques - 29 Jul 2005 23:36 GMT

I think your problem comes from using the Control Centre to define your
DBSAMPLE users.
When you use that function, it allows to identify, not define, which users
will connect and what privileges they will have.

To create users AND their passwords, you must use, on the server, that
server's security access methods to create the id and its password.

When you have done that, you can use the Control Centre to define these ids
and their privileges. Note that when you create these ids on the control
centre gui, DB2 thinks they are already definedand because of this the gui
does not prompt you for a password. It could not anyway as DB2 does not
validate the id and pwe.

HTH, Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> Maybe I explained to myself badly and it's probable seen that I'm a DB2
> neophyte.
[quoted text clipped - 26 lines]
> A way to set up the password of the users created in the DB exists or I
> must do it creating the user through the operating system?

Reply to this Message