473,387 Members | 1,585 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How to change the password and username of the database ?

how we can change the username and password of the database of db2 ?
Nov 29 '10 #1
4 4452
vijay2082
112 100+
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
Nov 29 '10 #2
thanks ,i know the concept of operating system concept ,But any other ways
Nov 29 '10 #3
vijay2082
112 100+
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
Nov 29 '10 #4
thanks ,I got solutions
Nov 30 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: pearl | last post by:
We have a primary OWA (5.5) server and a secondary OWA server. The primary OWA server's change password option truncates first letter of the username when prompted. The secondary OWA server does...
10
by: Fabrizio | last post by:
(Sorry for the crosspost, but I really don't know which is the right newsgroup!) Hi all, I try to change the password to a user that as to change the password at first logon: try {
0
by: Pavan | last post by:
Hi All, I am using Password Recovery control in order to reset my hashed passwords in ASP .Net 2.0 Beta 2. The system generated password is too difficult to remember, so i am giving Change...
3
by: Xnet | last post by:
I need to change password of a local user of a W2003, without Active Directory. I need to do it from an application created with VB2005. Thanks!
1
by: roshina | last post by:
Hi Iam facing a problem in my project, developing a web site for online shopping in ASP on windows XP using IIS server. All the validations are ok but the new password is not upadated in the data...
1
by: M Harris | last post by:
I have a production database that is password protected. Through my application, I want to provide the users with a COPY of this database, including RI, without a password or at least a different...
2
by: yasinirshad | last post by:
Hi, Please see my below code to change password. Here i need to check for old password from database and need to update new password. But when i try to submit by giving wrong old password ,its...
10
George Lft
by: George Lft | last post by:
In my new registration page, i'm trying to create a double entry password / username to validate their entry . haven't decided which one, probably i'll go just with the password . What is the PHP...
4
by: raj200809 | last post by:
Hi, I m trying update password in database using asp.net with c#. I have three text box in my aspx page Old password New password confirm password i m using following code but its not...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.