Re: Accessing objects in Forms

[Quoted] Colum Keegan <colum.keegan_at_lakefield.co.uk> escreveu no artigo <3492F4C2.A34_at_lakefield.co.uk>...
> Is there any way for user A to get access to user B's objects so that A
> can run these forms, without creating synonyms for all of user B's
> objects eg.
> CREATE PUBLIC SYNONYM emp for A.emp;
>

Hi,

I think you have only 3 options: use the syntax OWNER.OBJECT (except for procedures), create public synonyms or create views owned by the second user based on tables of the first (Ex: create view y.table1 as select * from x.table1).

Although it can seems a drawback, I think the use of public synonyms can be very flexible and powerful.

-- 
Luis Cabral
cabral_at_merconet.com.br