By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

DB2 V8 - user account TROUBLE

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
xevious wrote:
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?


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

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
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?

Nov 12 '05 #3

P: n/a

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
xevious wrote:
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?

--
Message posted via http://www.dbmonster.com
Nov 12 '05 #4

P: n/a
In article <52***********@DBMonster.com>, Juliane via DBMonster.com
(fo***@DBMonster.com) says...

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
Nov 12 '05 #5

P: n/a
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.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"xevious" <a.**********@gmail.com> a écrit dans le message de news:
11*********************@g49g2000cwa.googlegroups.c om...
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?


Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.