Re: Insert into table from different schemas

Mark,
  the problem is that the procedure is executed usually   "executed with the privileges of the owner of the schema   in which the procedure resides and that external names   resolve in the schema in which the procedure resides"

   Oracle 8.1 SQL Reference.

  With 8i you have the possiblilty to define the procedure   to run with privileges with and resolve external names in   schema of CURRENT_USER (the user executing the   procedure).

  For Pre 8.1 you would have to use dynamic SQL.

Regards
Dante
On Thu, 6 May 1999 21:42:25 +1000, "Mark Dexter Santos" <mdsantos_at_one.net.au> wrote:

>
>Hi all,
>
>Just a question from an oracle novice:
>
>How can I write a stored procedure in schema X which can insert data into
>the current user's schema???
>That way for different users, they can run the same procedure but it writes
>to their own private table
>
>Thanks in advance
>
>Mark
>
>
Received on Thu May 06 1999 - 11:00:57 CDT