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

[Quoted] Here's one technique to evaluate:

• grant all needed privileges on UserA's objects to RoleW
• grant RoleW to UserB (think about whether you need to password protect RoleW)
• create synonyms in UserB schema to point to all relevant objects in UserA schema (or, create PUBLIC synonyms to objects in UserA schema if this is more appropriate i.e. if there are many users in the UserB category.

Martin Doherty

IF wrote:

>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 Fri Nov 22 2002 - 22:34:45 CET