Re: Insert into table from different schemas

Hi

The procedure you are taking about should be a COMMON procedure.

Create the procedure in Sehema A,
create a public synonym for the procedure Grant execute access to all the users for this procedure

Prefix the private tables with the current oracle user name. This way you can have a COMMON procedure inserting records into PRIVATE tables of different users

Regards

N.Prabhakar

Mark Dexter Santos 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 Fri May 07 1999 - 02:49:33 CDT