The owner of public database links is PUBLIC.
The password is stored in SYS.LINK$.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Doug" <zuestra_at_hotmail.com> wrote in message
news:mf9cvsg9g0q36j78h8a7q6jo6365hca1ma_at_4ax.com...
> Hi.. sorry if this is a repeat post.. had some trouble earlier today
> on different client.
> With a database link, the user_db_links contains the password, wheras
> the dba_db_links does not.
> With a public database link, no one really seems to "own" it, so there
> is only all_db_links, and dba_db_links, neither of which contains the
> password.. the "identified by" clause.. Any simple answer to this?
> Thanks,
> Doug
Received on Wed Oct 25 2000 - 09:45:23 CDT
