Re: Oracle Developer Form 6.0 application

Try granting select on the underlying view tables to the user.

In article <9oUC3.217$tS.11609_at_nntp.csufresno.edu>,   stevec_at_zimmer.csufresno.edu (Steve Cosner) wrote:
>
> I think you should try getting your form to work in just one schema
> first. The errors you are getting don't appear to be related to
> accessing tables owned by other users.
>
> Steve Cosner
>
> In article <7rbk5u$lso$1_at_rcp6.elan.af.mil>,
> shirley <sschieck_at_ew.elan.af.mil> wrote:
> >I built an application using Form 6.0. The base table is owned by
schema
> >s-1. I grant the schema s-2 insert, update and delete privileges.
When s-2
> >uses the application, I get the errors frm-40501 and frm-40212. The
40212
> >error points to a field that is retrieved from a view owned by the
schema
> >s-3.
> >
> >I tried creating a public synonym for s-3's view as well as
recreating the
> >view with read only provision and the errors are still there.
> >
> >Suggestions, ideas or solutions would be greatly appreciated. Thank
you.
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 14:34:46 CEST