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

User password?

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

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


P: n/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.
Nov 12 '05 #2

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


Nov 12 '05 #3

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


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.