How to change the password and username of the database ?

[vijapandey]

how we can change the username and password of the database of db2 ?

[vijay2082]

Hi,

In DB2 UDB for LUW we don't maintain user id's in the database itself. DB2 relies on the external mechanism for mainatining database users and password e.g. OS, LDAP etc. Of course once userid has been created in the operating system then we can grant the required privileges/authorities in the database itself.

Coming to your original question, if you need to change the password then use the OS commands to chnage password for the user.
e.g. you can use passwd command to change user passwords on unix based system. On windows use the graphical interface to change the password. Once you chnage the password you just need to use new password to connect to the database ( No changes required from database side).

Cheers, Vijay

[vijapandey]

thanks ,i know the concept of operating system concept ,But any other ways

[vijay2082]

Hi,

Kindly elaborate your requirement with exact thing that you want to do ( What are you doing at present will give more insight if it's failing or was planned) ?

Cheers, Vijay

[vijapandey]

thanks ,I got solutions