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

I like the SYNONYM fix it will fix your problems and is flexible.

Next time you create a form either put in the schema name manually or get used to checking the Show All Users or Schemas checkbox. If that's checked it will put in the schema name automatically.

Elias Asfaw-Kirby
elias at icpsr umich dot edu

--
---
"IF" <tlfbi98_at_--quitalo--.terra.es> wrote in message
news:ii7ttu4rjnq3ke6ocknl7jmocci8agaeme_at_4ax.com...


> 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.