Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2006
    Posts
    4

    Unanswered: Change a Users password

    I created a user and forgot there password and I need to change it to something I know how the heck can I do that? I am very new to DB2. If you want just tell where the heck I can find it.

  2. #2
    Join Date
    Aug 2003
    Location
    austin,tx
    Posts
    104
    Depends on the authentication scheme you are using. By default, it will authenticate users to the local OS, so you would have to change the password through the OS.

  3. #3
    Join Date
    Mar 2006
    Posts
    4

    No user in the os

    Quote Originally Posted by craigmc
    Depends on the authentication scheme you are using. By default, it will authenticate users to the local OS, so you would have to change the password through the OS.
    There is no such user in the os just in the database.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Do not create users in DB2. You must create them (and change passwords) in the OS.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Mar 2006
    Posts
    4
    Opps. I created a schema with the same name as the user will it drop the schema objects? If not then I will create an os user and go from there.

  6. #6
    Join Date
    Mar 2006
    Posts
    4

    Got it

    Quote Originally Posted by vector23a7
    Opps. I created a schema with the same name as the user will it drop the schema objects? If not then I will create an os user and go from there.
    What I did was create an os user of the same name as the db user and then I could change passwords, connect to the db etc using the user information from the o/s.

    Thanks for pointing me in the right direction.


Posting Permissions

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