If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > How to change password in UDB DB2 ?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Feb 2004
Posts: 34
How to change password in UDB DB2 ?

OS = Win NT
DB2 = 6.1 UDB

How to change specific user id's password here ?

please advice.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Posts: 4,123
Change the password in the OS--in your case WIN NT.

Andy
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Quote:
Originally Posted by dingi
OS = Win NT
DB2 = 6.1 UDB

How to change specific user id's password here ?

please advice.
Change it at the OS level, in your case through Windows.

Or on the connect:
CONNECT TO database-alias
USER <userid> USING <ps>
NEW new-password CONFIRM confirm-password

(Not sure if that existed in 6.1 though, might be new to 7 or 8)
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Posts: 1,595
Hi J_Petruk,

If changed with connect command, must it be changed at OS level also?

Thanks,
Grofaty
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Quote:
Originally Posted by grofaty
Hi J_Petruk,

If changed with connect command, must it be changed at OS level also?

Thanks,
Grofaty
No, that changes it at the OS level.

Doesn't work in all cases I've found, I had some trouble with Windows domains.
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Jul 2003
Location: Austin, TX, USA
Posts: 278
Service Level

Hi,

Please do the following.

1. Change the OS password.

2. Change the service level passwords for all DB2 Services.

This will work.
__________________
HTH

Nitin

Ask the experienced rather than the learned
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Feb 2004
Posts: 34
new users

I also need to create new users who will not be DB2 administrator but just simple developers.

How should i do ?
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Jul 2003
Location: Austin, TX, USA
Posts: 278
OS Users

Hi,

Just create OS Users with user privileges, you don't need to give them any special permissions at the OS Level.

Then logging on to the database as db2admin or your database admin user go ahead and give them object level and schema level privileges.

Please refer to the db2 documentation or administration guide for more details.
__________________
HTH

Nitin

Ask the experienced rather than the learned
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Just a note of caution, db2 defaults to be pretty wide open, you'll probably want to revoke rights from PUBLIC, make sure these users can't do anything, then give them access to what you want them to have access to.

This is one task I like the Control Center for, it gets tedious selecting from syscat tables and issuing commands from the command line.

(I created a db justnow, PUBLIC by default has CREATETAB, BINDADD, CONNECT, IMPLICITSCHEMA... so any OS user can do a heck of a lot more than you'd probably want by default)
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
  #10 (permalink)  
Old
Registered User
 
Join Date: Feb 2004
Posts: 34
Thumbs up Thanks to all........for standing with me

Thanks to all........for standing with me
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
Join Date: Mar 2004
Location: Spain
Posts: 7
Talking

So, one question:

If I change my db2 user password, am I changing my windows user password too?

I want to install db2 on a server being the db2 administrator, but I'm not the server administrator, so I think I have to install it using server administrator loggin and password and then change the password, isn't it?


I need some help in this quetion because I have to do it in a very short time.


Thanks a lot.
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Quote:
Originally Posted by dobell
So, one question:

If I change my db2 user password, am I changing my windows user password too?

I want to install db2 on a server being the db2 administrator, but I'm not the server administrator, so I think I have to install it using server administrator loggin and password and then change the password, isn't it?


I need some help in this quetion because I have to do it in a very short time.


Thanks a lot.
Yes - if you change your password using the db2 CONNECT command, it changes the operating system password.

I don't understand your second question... can you rephrase? You need to install with a user that has Administrators group access on the machine, and has "Act as part of the operating system" rights. The instance IDs are separate from that install id. (See the Quick Beginnings)
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
  #13 (permalink)  
Old
Registered User
 
Join Date: Mar 2004
Location: Spain
Posts: 7
I reprhase my second question:

I want to install db2 on a Windows 2000 server. I want different passwords for the db2 administrator and the windows system admin, so I think I have to create other windows user, having administration permissions, and install db2 using this user and password, but have I to be logged in the system as this new user, or the original administrator?


Thanks.
Reply With Quote
  #14 (permalink)  
Old
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Quote:
Originally Posted by dobell
I reprhase my second question:

I want to install db2 on a Windows 2000 server. I want different passwords for the db2 administrator and the windows system admin, so I think I have to create other windows user, having administration permissions, and install db2 using this user and password, but have I to be logged in the system as this new user, or the original administrator?

Thanks.
You can install with any id that is in the Administrators group, it doesn't make a difference. During the install you're promted for the ids for the db2 instance and admin.
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
  #15 (permalink)  
Old
Registered User
 
Join Date: Jun 2009
Posts: 14
About the OS passwords

Hi,
i have given a read to this link here:
DB2 UDB security, Part 1: Understand how user and group accounts interact with DB2 UDB
it summarily describes the authentication in DB2.

Basically what it tells you is that when you provide DB2 a user name and password, for example through a JDBC connection, it will feed the pair to the OS and await an OS reply to determine if the user name and password are valid OS accounts.

Now given this authentication method I fail to understand what is happening when, for example, i do Connect To sample;

In this case, i the DB2 tools were able to connect me to DB2 using a JDBC connection without supplying either user or password information. It just kind of bypassed security. I wonder how?

Another problem is, my everyday Windows user does not use any password. I do not need it, i am working at home for college so i do not want to put any security in the OS that is not really strictly necessary.

So the problem is this:
1) The DB2 tools, like the control center or command line tools (db2cmd), are capable of connecting me to the database (and i do not supply any password)

2) But when i use SQLExplorer for development i have to configure the JDBC connection and supply a pair Username and Password. Do i really have to reocnfigure my OS accounts?

(I do not want to change the Authentication Mode from the default mode which seems to be "Server")
Thanks in advance.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On