Home » RDBMS Server » Security » windows authentication and connection in Oracle (Oracle 11.2.0.3, OS windows 2008 R2)
windows authentication and connection in Oracle [message #590201] Mon, 15 July 2013 15:10 Go to next message
patdev
Messages: 53
Registered: August 2008
Member
hi all,

I am very much confuse about this topic. I have been using oracle based database security but company now wants to handle with windows authentication.
I have windows os 2008 R2 and oracle 11.2.0.3.
I also have set up the SQLNET.AUTHENTICATION_SERVICES= (NTS)
I created user with create user "domain\username" identified Externally!!
but now how can i connection from application to database!!
Please guide or provide direction please!!

thanks

Pat

*BlackSwan removed all the superfluous blank lines

[Updated on: Mon, 15 July 2013 15:34] by Moderator

Report message to a moderator

Re: windows authentication and connection in Oracle [message #590227 is a reply to message #590201] Tue, 16 July 2013 00:14 Go to previous message
Michel Cadot
Messages: 58913
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If your application does not reside in the same server than the database, you can't (well technically you can but this is the biggest hole you can ever make in the security which means you have no security at all and anyone can connect to your database).
If you want to be authenticated by Windows AD, you can use Oracle Entreprise User but this requires you buy Oracle Security Option.

Regards
Michel
Previous Topic: auditing DB access through ColdFusion
Next Topic: Oracle Wallet Open Failed
Goto Forum:
  


Current Time: Wed Aug 27 16:13:59 CDT 2014

Total time taken to generate the page: 0.15803 seconds