I have a form which is used by multiple users. This form calls a procedure which updates 2 tables. The users each have these tables set up in their own schema.
How do I get the procedure to use the tables in the schema of the user running the form (I need to keep the data for each user in their seperate tables)? The users do not own the procedure.
Any help or direction would be appreciated.


[Edited by kfkudo on 12-14-2000 at 07:06 PM]