Re: Saving data in another schema using Forms 4.5

Rao's reply:

You need to create public synonyms to your objects and grant access on those objects to the desired oracle users or public..

when your program accesses a table X oracle accesses actually <your_oracle_username>.X table..

Amit Sharma wrote:
>
> Hi all,
> The application I developed using Forms 4.5 is based on tables
> created in my schema.
> I have installed the application on somebody's else's machine.
> Everything works fine
> but it won't save the data in my tables. He has the permissions on all
> my tables.
>
> What code should be written in the save button trigger so that the data
> is stored in the
> table in my schema even if he is running the application, logged on as
> himself rather than as me. Or anything else which could be done.
>
> Please let me know.
>
> Thanks in advance
>
> Amit
  Received on Wed Nov 05 1997 - 00:00:00 CET