473,382 Members | 1,657 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,382 software developers and data experts.

Identifying a password for the newly created user to a database in DB2

Hi,

I have created a new user for a database that i hav created in DB2, by expanding the database tree diagram in control center right upto DB users folder, and then right clicking it and selecting "Add...".

It opens up a window, where we hav to specify the name of the user, and the various privileges to the new user.

if we click"ok" the new user is created.

BUT THE PROBLEM IS I DON'T KNOW WAT IS THE PASSWORD (or DEFAULT PASSWORD) FOR THE NEWLY CREATED USER.

Because there is no such option for providing a password for the new user!!!

Please someone help me!!!
Dec 24 '06 #1
2 1543
Thank u for ur reply

also the username & password i used is one u give while installing db2.
now if u create a new user and a table in it u can access it by username.tablename

in my program db2admin & varma are the user name & password i gave while installing db2. VARMA is my created user in db2 & student is a table in it.so i accessed it as VARMA.STUDENT and there is no need of a password for that.

hope u understood.byeeeeeeeee
Dec 25 '06 #2
Hi kommaraju,

i jus wanted to know how did u give the password for the new user VARMA that u created on DB2, or how to know that, apart from the db2admin user that u give during installation.


Thank u for ur reply

also the username & password i used is one u give while installing db2.
now if u create a new user and a table in it u can access it by username.tablename

in my program db2admin & varma are the user name & password i gave while installing db2. VARMA is my created user in db2 & student is a table in it.so i accessed it as VARMA.STUDENT and there is no need of a password for that.

hope u understood.byeeeeeeeee
Dec 25 '06 #3

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

Similar topics

3
by: compassSoftware | last post by:
Hi, When I create a new database from Enterprise Manager (right click on databases > New Database) I noticed that I am not prompted to create a password or user name. Can I take it then that all...
3
by: Mike Wiseley | last post by:
I created a desktop shortcut with "C:\Program Files\Microsoft Office\MSAccess.exe" "C:\My Documents\CopyAToB.mdb" /pwd "password: The trouble is that when running this shortcut, it prompts first...
3
by: Whitey | last post by:
I have a password secured database. After the password is entered the user has a form that I created that allows them to search the database and retrieve information. The problem is that the...
0
by: raza | last post by:
I am trying to create a new mdb in C# using ADOX, i am able to create DB , i want to add a username/password on that db , i have tried so many things , cant make it to work , please help ...
6
by: Anita | last post by:
I have problem opening my existing projects or newly created project. It asks me for user name and password and if I provide then it allows me to open but when I debug either it gives error message...
8
by: oaksong | last post by:
I had a web page that worked very nicely until I changed the SA password. The page used data widgets for connectivity to SQL server. I changed the password in the Server Explorer link, but the...
6
by: Frank L | last post by:
I have some accounting and tax receipting type applications, developed for charitable and non profit groups, that are exhibiting strange behaviour on a few of the 30 or 40 user machines. When...
4
by: clintonG | last post by:
When the password is hashed and most secure this control mails a new password to anybody that provides an authenticated user name. The previous password can no longer be used to login. The newly...
4
by: =?Utf-8?B?R2hpc3Rvcw==?= | last post by:
Hi, I collect hashed password in my BD. I give the opportunity to the user to reset his password with the PasswordRecovery control. But, when he receive it , it is a series fo strange characters...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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?

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.