Accessing another user's tables

From: Michael Collins <mikecollins_at_cix.compulink.co.uk>
Date: Tue, 7 Jun 1994 23:03:46 GMT
Message-ID: <Cr1uqA.AJI_at_cix.compulink.co.uk>


In reply to ...

> A user, scott, has some tables and some forms that manipulate
> those tables. Another user, john, wants to run those forms.
> After granting access to his tables to john (or public), I would
> have thought that scott should refer to his tables (in his
> form's code) as scott.tablename. Instead, a colleague suggested
> using the unadorned tablename and creating (public) synonym(s)
> for scott's tables.
>
> Any thoughts on which approach to prefer? Thanks.
>

It all depends (groan!) on whether Scott is likely to give his tables to Jane (i.e. the tables are likely to move ) in which case synonyms would be a more flexible approach.

Public or Private synonyms again depend on whether there are other versions of Scotts tables about.

I would say it's more flexibe to use Synonyms and , if in a development environment , private ones.

Mike Collins
( MikeCollins_at_cix.compulink.uk ) Received on Wed Jun 08 1994 - 01:03:46 CEST

Original text of this message