Newbie - Db2 security and windows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alberto Salvati - 07 Aug 2006 17:31 GMT

Hi, list.
I don't want that my users uses windows security to logon on db2
database.
I want my db2 server to ask user for userid and password to access my
db.

Did you know if exists a link/whitepaper/pdf/txt... that explains how i
can make it?
Can i do it AFTER server installation?
More, can I install db2 server with db2 authentication as default
insthead windows authentication?
Today is my first time on db2...
I'm thinking about "WHY db2 doesn't ask dba about authentication mode
each time he needs to create a new user?" ... :-((

TIA

Alberto Salvati

Reply to this Message

m - 07 Aug 2006 18:48 GMT

> Hi, list.
> I don't want that my users uses windows security to logon on db2
[quoted text clipped - 14 lines]
>
> Alberto Salvati

UDB for LUW can ONLY use the OS to authenticate users.

Reply to this Message

Alberto Salvati - 08 Aug 2006 07:51 GMT

> UDB for LUW can ONLY use the OS to authenticate users.

LUW?? What's LUW? :-|

A.

Reply to this Message

Mark A - 08 Aug 2006 07:56 GMT

> LUW?? What's LUW? :-|
>
> A.

Linux, UNIX, Windows.

There is also DB2 for z/OS (mainframe), and DB2 for iSeries (AS/400).

Reply to this Message

Frank Swarbrick - 09 Aug 2006 00:29 GMT

And DB2 Server for VM and VSE.

:-)

>>> Mark A<nobody@nowhere.com> 08/08/06 12:56 AM >>>
> LUW?? What's LUW? :-|
>
> A.

Linux, UNIX, Windows.

There is also DB2 for z/OS (mainframe), and DB2 for iSeries (AS/400).

Reply to this Message

Knut Stolze - 07 Aug 2006 20:33 GMT

> Hi, list.
> I don't want that my users uses windows security to logon on db2
> database.
> I want my db2 server to ask user for userid and password to access my
> db.

You may want to implement your own user exit. Then you can use any
mechanism you like for authentication purposes.

> Did you know if exists a link/whitepaper/pdf/txt... that explains how i
> can make it?
> Can i do it AFTER server installation?
> More, can I install db2 server with db2 authentication as default
> insthead windows authentication?

There is no such thing as "db2 authentication".

> I'm thinking about "WHY db2 doesn't ask dba about authentication mode
> each time he needs to create a new user?" ... :-((

Because DB2 does not manage users in the first place. That's the job of the
operating system or other components like Kerberos or LDAP.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Knut Stolze - 07 Aug 2006 20:35 GMT

>> Hi, list.
>> I don't want that my users uses windows security to logon on db2
[quoted text clipped - 4 lines]
> You may want to implement your own user exit. Then you can use any
> mechanism you like for authentication purposes.

Sorry, I meant "security plugin" instead of "user exit".

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Alberto Salvati - 08 Aug 2006 07:54 GMT

> There is no such thing as "db2 authentication".

I'm not happy, now.... :-((

> Because DB2 does not manage users in the first place. That's the job of the
> operating system or other components like Kerberos or LDAP.

Tnx.

A.

Reply to this Message