Re: database link as user PUBLIC

bernhard labus wrote:
>
> Hello everybody,
>
> maybe someone knows:
> How can I create a database link as user PUBLIC,
> ***I don't mean*** a public database link.
>
> I am on database A and want to query a public synonym on database B.
> when I try
> create database link LINKTOBasPUBLIC connect to PUBLIC using 'B',
> ORA-00987: missing or invalid username(s)
> or
> create database link LINKTOBasPUBLIC connect to PUBLIC identified externally
> using 'B',
> ORA-00987: missing or invalid username(s)
>
> Thanx in advance
> Bernhard

Just create a link that connects to an account that has only 'create session' priv on the target. It will then only be access objects that have been granted to public.

HTH
Connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"