Re: One set of stored procedure for multiple users

Hongtao Gu <hgu_at_honshu.tbu.att.com> wrote in article <5abh78$46j_at_nntpb.cb.lucent.com>...
> 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).

This is one of those weird deals. How about this: Have the stored procs work off of public synonyms. Create some code that selectively drops and recreates those public synonyms to point to the schema that you want. It could be another stored procedure that takes a parameter of the new schema name. It drops all of the synonyms and then recreates them with the new schema name. Might this work?

Roger Received on Thu Jan 09 1997 - 00:00:00 CST