Re: One set of stored procedure for multiple users

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.
>

This can be done by creating stored procedures in one of the users schema and give execute privilages for the others users to execute the procedures.
hope this helps

AMARENDRA

-- 
    AMARENDRA B NETTEM
    ORACLE CONSULTANT
    WHITTMAN-HART CORPORATION, CHICAGO
    (http://www.iit.edu/~nettama)