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

Martin Doherty wrote:

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

Provided none of those privileges is required by a package, function, or stored procedure???

Daniel Morgan Received on Sat Nov 23 2002 - 00:43:54 CET