Re: Accessing objects in Forms

Luis Cabral wrote:

> 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

There is another option that is more limited than PUBLIC synonyms: create PRIVATE synonyms for just those users that are to have access. Doing so eliminates the need to use the owner.tablename syntax.

Hank Freeman
hfreeman_at_lodinet.com Received on Sun Dec 14 1997 - 00:00:00 CET