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

From: IF <tlfbi98_at_--quitalo--.terra.es>
Date: Fri, 22 Nov 2002 21:22:21 GMT
Message-ID: <ii7ttu4rjnq3ke6ocknl7jmocci8agaeme_at_4ax.com>

[Quoted] [Quoted] I am developing a forms 6.0 application. UserA is the owner of all [Quoted] 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 Fri Nov 22 2002 - 22:22:21 CET