Re: One set of stored procedure for multiple users

On 31 Dec 1996 17:06:48 GMT, hgu_at_honshu.tbu.att.com (Hongtao Gu) wrote:

>Please help us to find a good solution for this problem.
>
>This is a development shop. We deliver one version of software to six
>different users. To offer technical support, we have to keep one set of
>data in our DB for each customer. As a result, in our Oracle DB, there
>are six users, each of them has a same set of tables, but the data in
>the tables are different. Now, we install one set of stored procedure
>for each user. If we modify/add a stored procedure, we have to intall
>it six times, once for one user. This is annoying.
>
>We are looking for some method to simplify the process: install
>one set of stored procedure for all the users. Because of large number of
>existing store procedures (> 400), using dynamic SQL seems not a very
>desirable solution (big work load for modify/test the procedures + possible
>performance degration).
>
>Anybody can suggest a better solution?
>
>Thanks.
>
>Hubert from Lucent Technologies.
>

Assuming that all six users are stored within the same instance, why not just install the stored procedures under one of the user accounts and create public synonyms in the other 5 user accounts to point to the single set?

Regards,
Dave Macpherson Received on Thu Jan 02 1997 - 00:00:00 CST