Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,126
    Change the password in the OS--in your case WIN NT.

    Andy

  3. #3
    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

  4. #4
    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

  5. #5
    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

  6. #6
    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

  7. #7
    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 ?

  8. #8
    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

  9. #9
    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

  10. #10
    Join Date
    Feb 2004
    Posts
    34

    Thumbs up Thanks to all........for standing with me

    Thanks to all........for standing with me

  11. #11
    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.

  12. #12
    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

  13. #13
    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.

  14. #14
    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

  15. #15
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •