| windows authentication and connection in Oracle [message #590201] |
Mon, 15 July 2013 15:10  |
patdev
Messages: 74
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  |
 |
Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
