User password?

[ibm_97@yahoo.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!

[Mark A]

Re: User password?

<ibm_97@yahoo.c om> wrote in message
news:1118696469 .702366.198720@ g43g2000cwa.goo glegroups.com.. .[color=blue]
> 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!
>[/color]
User id's and passwords are controlled by the OS.

[Pierre Saint-Jacques]

Re: User password?

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
<ibm_97@yahoo.c om> a écrit dans le message de news:
1118696469.7023 66.198720@g43g2 00...legr oups.com...[color=blue]
> 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!
>[/color]

[ibm_97@yahoo.com]

Re: User password?

Thnx to all.

Pierre Saint-Jacques wrote:[color=blue]
> 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
> <ibm_97@yahoo.c om> a écrit dans le message de news:
> 1118696469.7023 66.198720@g43g2 00...legr oups.com...[color=green]
> > 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!
> >[/color][/color]