Printable View
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]
One way is grant the user level update/insert/select/delete privileges on those tables to the other user's schema. then those users could do the update on those schema tables just by specifying the schema_owner.table_name. Another way is that the user could grant the access previleges to those tables to the other users and then those grantees would be able to access those tables by schema.table.
Good luck,
Sam
Or if u want even you can create Public Senonyms so that they are available to everyone. But may be it is better to give access to only required user