Skip to main content

developerworkslabel >  Information Management  >  forumlabel  >  DB2 Express  >  developerWorks

Questions about users    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     
 
 
loginbox.header
 loginbox.welcomelabel loginbox.guestlabel
loginbox.signin
This question is not answered.

Reply to this Thread Reply to this Thread Post New Thread Post New Thread useraction.watchpage useraction.watchpage useraction.settings useraction.settings help.pagetitle help.pagetitle
Permlink Replies: 1 - Pages: 1 - Last Post: Sep 28, 2009 10:30 AM Last Post By: alvin
velle

Posts: 4
Registered: Sep 26, 2009 03:43:21 AM
Questions about users
Posted: Sep 26, 2009 10:35:41 AM 		 
Click to report abuse...   Click to reply to this thread Reply
1) When I am logged onto Windows as user Mickey, is it possible to log onto my database with db2ce (or db2 command line tool) as another user Joey. This would be nice for learning how to administrate privileges.

2) (JDBC) If I have a user on my OS, with no password, and I have created the same user in the database, how can I log on to the database from a java program. I have tried supplying an empty string and null as password, with no luck.

2) Why does db2cc allow me to create a user, that does not exist on the OS. What is this useful for?

thanks, velle
alvin

Posts: 21
Registered: Jan 10, 2006 11:06:03 AM
Re: Questions about users
Posted: Sep 28, 2009 10:30:09 AM   in response to: velle in response to: vellethread.responsepost 		 
Click to report abuse...   Click to reply to this thread Reply
You can always connect to the database with a different userid.
For example, if you have logon to Windows as Mickey you can connect to the database using CLP as Daisy and another one as Pluto. Each will have to be done on a separate CLP command line.

In one CLP command window you connect as Daisy:
c:\>db2 connect to sample user Daisy

In another CLP command window you connect as Pluto:
d:\>db2 connect to sample user Pluto

Regards,
Alvin.
Pages: 1
Go Back Back to Thread List
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 
MoreLess 

Update your My developerWorks profile and start connecting with others.

Point your RSS reader here for a feed of the latest messages in all forums