Re: One set of stored procedure for multiple users

Dave Macpherson wrote:

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

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

Since Stored procedure runs in the owner's priviledge domain, just grant execute
priviledge to other users and create synonym cannot achieve stated goals.

Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049