Home » SQL & PL/SQL » SQL & PL/SQL » DB LINK for OPS$ user
DB LINK for OPS$ user [message #240218] Thu, 24 May 2007 07:04 Go to next message
ganeshsv
Messages: 51
Registered: January 2006
Member
Hi
How can I create a DB LINK where connect to user is a OPS$ user.

Thanks in advance
SG
Re: DB LINK for OPS$ user [message #240261 is a reply to message #240218] Thu, 24 May 2007 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know but it is a very bad idea and a hole in security if this can be done.

Regards
Michel
Re: DB LINK for OPS$ user [message #240440 is a reply to message #240261] Thu, 24 May 2007 19:20 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
It can't be done the way you hope. "Externally authenticated" accounts cannot be accessed via a password.

They can be accessed from the database sever (obviously) and they can also be accessed (I think) via a proxy server. I have no idea how this works - I've never done it. It may or may not help you. Search the doco of Externally Authenticated accounts.

Ross Leishman
Re: DB LINK for OPS$ user [message #240441 is a reply to message #240218] Thu, 24 May 2007 19:22 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Externally Authenticated accounts are typically validated by OID/LDAP server.
Previous Topic: size of varchar2 in pl/sql
Next Topic: HELP STATEMENT WITH IN (merged)
Goto Forum:
  


Current Time: Mon Dec 05 20:55:18 CST 2016

Total time taken to generate the page: 0.09433 seconds