Re: URGENT: How to access other user's tables inside a forms 6.0 application

Try getting UserA to create a public synonym for the tables.

I.e.

create public synonym table1 for UserA.table1.

Regards
Douglas Mitchinson
http://www.cetax.demon.co.uk

In message <ii7ttu4rjnq3ke6ocknl7jmocci8agaeme_at_4ax.com>, IF <tlfbi98_at_--quitalo--.terra.es> writes
>I am developing a forms 6.0 application. UserA is the owner of all
>tables, so when UserAconnects to the forms application he/she can
>access to all tables. The problem arises when UserB connects to the
>forms application. Since he/she is not the owner of the tables
>(although he/she has granted select privileges to access the tables)
>forms cannot find the tables because the select statements inside the
>application doesn't include the schema name. That is the select
>statements are in the form: SELECT * FROM TABLE1 instead of SELECT *
>FROM UserA.TABLE1.
>
>I have thought of using an ALTER SESSION SET DEFAULT_SCHEMA = USERA
>sentence inside a post_logon trigger but forms doesn't allow me to do
>this.
>
>How can I execute the ALTER SESSION SET DEFAULT_SCHEMA = USERA from
>inside a forms application?
>
> Is there a package that allow me to do the same thing?
>
>Is there any other way to easily allow one user to access tables form
>another user schema when the SQL sentences dosn't include the schema
>name?
>
>I really urgently need your help.
>
>Thanks in advance.
Received on Wed Nov 27 2002 - 11:20:24 CET