Re: help calling procedure in package from different users

From: Frank van Bortel <>
Date: Tue, 29 Jan 2008 20:04:50 +0100
Message-ID: <9ecb7$479f78d2$524b5c40$>

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.


Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Tue Jan 29 2008 - 13:04:50 CST

Original text of this message