Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    37

    Unanswered: changing user password on db28.1 for linux

    hi all,

    is there any way to change the database user password on db2 udb 8.1 for linux without using unix command "passwd" on operating system?

    thanks

    bab

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2 connect to <dbname> user <username> using <current password> new <new password> confirm <new password>
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2004
    Posts
    37
    Quote Originally Posted by sathyaram_s
    db2 connect to <dbname> user <username> using <current password> new <new password> confirm <new password>

    hi sathyaram,

    thank you.

    hmmm .. but why have i to create the database user on operating system? or ist there any way too to create a database user without command useradd?

    thanks

    bab

  4. #4
    Join Date
    Feb 2004
    Posts
    37
    Quote Originally Posted by bab
    hi sathyaram,

    thank you.

    hmmm .. but why have i to create the database user on operating system? or ist there any way too to create a database user without command useradd?

    thanks

    bab
    and when i try to change the password i became this message:

    SQL30083N Attempt to change password for user id "17" failed with security
    reason "UNSUPPORTED FUNCTION" (""). SQLSTATE=08001


    what need db2 to support this function?

  5. #5
    Join Date
    Sep 2003
    Posts
    27
    In red hat , if u need to change to password, seems u have to change at /etc/passwd and /etc/shadow. u cant change by using the command as the above said. U can try to write script for user to change the password

Posting Permissions

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