Re: public database link password?

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 31 Aug 1999 14:01:50 GMT
Message-ID: <7qgn8e$aos$1@news.seed.net.tw>

Doug Cowles <dcowles_at_bigfoot.com> wrote in message news:37CA8F0C.D6BC508E_at_bigfoot.com...
> With private database links, you can check the password and loggin in as
> the owner and doing a select * from user_db_links. If you are not the
> owner, you don't get the password in all_db_links, dba_db_links etc.,
> However, with a public database link, I can't find the password
> anywhere, if I am sys, or system, all views seem to hide the password.
> Who owns public objects and how can I find a link password? Or can I?
>
> Dc.

The owner of public database links is PUBLIC. The password is stored in SYS.LINK$. Received on Tue Aug 31 1999 - 09:01:50 CDT