User password?

[ibm_97]

Hi,

Since I work mainly on Oracle, I got the problem regarding DB2 user.

I create new 'DB User' from Control Center. How do I set the password
for this new user? Or, the only way to do this is to create a new OS
user with the same username? If so, can I still connect as this new
user to db2? (what's the password?)

Thanks a lot!

[Mark A]

<ib****@yahoo.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Hi,

Since I work mainly on Oracle, I got the problem regarding DB2 user.

I create new 'DB User' from Control Center. How do I set the password
for this new user? Or, the only way to do this is to create a new OS
user with the same username? If so, can I still connect as this new
user to db2? (what's the password?)

Thanks a lot!

User id's and passwords are controlled by the OS.

[Pierre Saint-Jacques]

You need to read a bit from the DB2 Quick Beginnings install book for your
platform.

DB2 has no concepts of a database user as Oracle does.
For DB2, one creates an OS user and pw.
Once it exists, it is seen as a member of the PUBLIC group from a DB2 point
of view. By default, all db's created in DB2 give connect privilege to
members of PUBLIC. You can change this if needed.

If the user exists, then use the Control Center to identify that user by
tyoing its id and then set the privileges as you see fit.
The control Center function is there to let you set privileges for ids.
They may or may not exist in reality on the OS security access method but
DB2 will take note of them anyway.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ib****@yahoo.com> a écrit dans le message de news:
11**********************@g43g2000cwa.googlegroups. com...

Hi,

Since I work mainly on Oracle, I got the problem regarding DB2 user.

I create new 'DB User' from Control Center. How do I set the password
for this new user? Or, the only way to do this is to create a new OS
user with the same username? If so, can I still connect as this new
user to db2? (what's the password?)

Thanks a lot!

[ibm_97]

Thnx to all.

Pierre Saint-Jacques wrote:

You need to read a bit from the DB2 Quick Beginnings install book for your
platform.

DB2 has no concepts of a database user as Oracle does.
For DB2, one creates an OS user and pw.
Once it exists, it is seen as a member of the PUBLIC group from a DB2 point
of view. By default, all db's created in DB2 give connect privilege to
members of PUBLIC. You can change this if needed.

If the user exists, then use the Control Center to identify that user by
tyoing its id and then set the privileges as you see fit.
The control Center function is there to let you set privileges for ids.
They may or may not exist in reality on the OS security access method but
DB2 will take note of them anyway.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ib****@yahoo.com> a écrit dans le message de news:
11**********************@g43g2000cwa.googlegroups. com...

Hi,

Since I work mainly on Oracle, I got the problem regarding DB2 user.

I create new 'DB User' from Control Center. How do I set the password
for this new user? Or, the only way to do this is to create a new OS
user with the same username? If so, can I still connect as this new
user to db2? (what's the password?)

Thanks a lot!