Re: help calling procedure in package from different users

Martin wrote:

> thanks. This seems to work for everyone:
>
> create public synonym testsynonymn for user1.package1
> begin testsynonym.procedure1(args); end;
>
> Anyone have any other suggestions as this would require the creating
> of a massive number of synonyms?
>
> Martin

One of:
- automate the synonym creation (write a script,   that delivers the correct statement)
- rethink you strategy of having so many users, that all own a couple of procedures. It is far more customary to have one or two users that "own" the application: data, procedures, etc.

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up