Home » RDBMS Server » Security » user authentication while using database link
user authentication while using database link [message #412895] Mon, 13 July 2009 05:25 Go to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hi,
I am using database link to connect to remote database in my application. I want to authentication while connecting to remote database. Please help me out. I have gone through Oracle advance security and learnt about Kerberos but I am not getting how to install Kerberos server and use it for authentication. how to install Kerberos server. Any information will be helpfull.

Regards,
Shekar Salunkhe
Re: user authentication while using database link [message #412899 is a reply to message #412895] Mon, 13 July 2009 05:45 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, in order to create a database link, you have to provide password (by using the IDENTIFIED BY clause). So, if you already have created the database link, it means that you know the password. Why would you want to perform another identification?
Re: user authentication while using database link [message #412901 is a reply to message #412895] Mon, 13 July 2009 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is the same principle if you use kerberos to authenticate.

How to install is explained in documentation.
Using Kerberos to authenticate in Oracle requires ASO (Advanced Security Option) which is far from free.

Regards
Michel
Re: user authentication while using database link [message #412903 is a reply to message #412895] Mon, 13 July 2009 06:10 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Thanks for reply, as far I can understand, There is option in Net Manager for Kerberos configuration. Only addtional requirement is Kerberos server or we need to have a totally new configuration system.
Re: user authentication while using database link [message #412913 is a reply to message #412903] Mon, 13 July 2009 06:49 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/print_hit_summary?search_string=kerberos

Regards
Michel
Previous Topic: Need to find out how database got truncated.
Next Topic: Connect sys@my_tns as sysdba, fail (ora-1031)
Goto Forum:
  


Current Time: Thu Mar 28 17:16:00 CDT 2024