Home » RDBMS Server » Security » Encrypt 9i database link (9.2.0)
Encrypt 9i database link [message #478860] Wed, 13 October 2010 01:24 Go to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
hi,

can any one tell me how to encrypt 9i database-link passwords?
In 10g when we browse the link it show **** but in 9i it shows the
actual password. Any workaround?

Thanks in advance
Re: Encrypt 9i database link [message #478863 is a reply to message #478860] Wed, 13 October 2010 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: Encrypt 9i database link [message #478864 is a reply to message #478863] Wed, 13 October 2010 01:47 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member

Sad nothing possible? I have found metalink note 312190.1 describing possibility. But will be interested if something else
can be done. Thanks Michel for update.
Re: Encrypt 9i database link [message #478869 is a reply to message #478864] Wed, 13 October 2010 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes this note gives a workaround (why don't you post it before?).
It allows to hide the password from standard user. Is this what you want?
What does not it answer to your issue (I think it does not as you asked for something here)?

Regards
Michel
Re: Encrypt 9i database link [message #478870 is a reply to message #478869] Wed, 13 October 2010 02:07 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Yes, but i am looking for any workaround so that user who owns the dblink couldn't see the password either.
Re: Encrypt 9i database link [message #478879 is a reply to message #478870] Wed, 13 October 2010 03:01 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not possible unless you remove or change USER_DB_LINKS view.
Only do this with the backing of Oracle support.

Regards
Michel
Previous Topic: SSO Outside of Forms
Next Topic: SSL, WebAPPs and database
Goto Forum:
  


Current Time: Thu Mar 28 18:42:01 CDT 2024