aspose file tools*
The moose likes JDBC and the fly likes User Authentication from java application to a database without giving the password Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "User Authentication from java application to a database without giving the password" Watch "User Authentication from java application to a database without giving the password" New topic
Author

User Authentication from java application to a database without giving the password

sambasiva kumar
Greenhorn

Joined: Jan 16, 2007
Posts: 24
Hi Folks,

I am trying to authenticate a user and connect to the database without giving the password.

The other thing is that we should not use the properties file to set the Username and Password, which we generally do to connect to a data base using the DSN names, etc.,


I had gone through the User Authentication using the Windows.
and also the data direct but could not find a solution.

please let me know if any feasible solution for this.

Thanks in advance.

cheers
Sambasiva
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

"kumarsambasuresh kumarsambasuresh"

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
Scott
JavaRanch Bartender


My Blog: Down Home Country Coding with Scott Selikoff
sambasiva kumar
Greenhorn

Joined: Jan 16, 2007
Posts: 24
Hi,

Thanks for the suggestion.
Somebody give me the solution for this query.

Thanks in Advance.

Cheers
Sambasiva
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Whether you can do this will probably be determined by which RDBMS you are using. For example, it is possible to use NTLM authentication with SQL Server (assuming your driver is jTDS). Which database are you using?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
sambasiva kumar
Greenhorn

Joined: Jan 16, 2007
Posts: 24
hi,

i am using Oracle10g.

Thanks in advance

cheers
Sambasiva
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Well, I've never heard of anyone doing it, but I understand you can configure an external authentication source for an Oracle database, with could be an Active Directory repository. But that's the database itself -you'd also need a driver that support NTLM and I don;t think the drivers supplied with Oracle do (you'd better check this - I'm not 100% sure). You might have to buy a third party driver such as DataDirect.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: User Authentication from java application to a database without giving the password