Newsgroups: comp.databases
Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!wuarchive!uunet!modcomp!angel
From: angel@modcomp.uucp (Pam Angel)
Subject: operator access to SQL*FORMS 2.3 (RDBMS 6.0)
Message-ID: <angel.677525013@glsdev>
Summary: Form written by one user cannot be accessed by others.  
Sender: news@modcomp.uucp (Mr. News)
Organization: MODCOMP, an AEG company
Date: Fri, 21 Jun 1991 17:23:33 GMT
Lines: 27


I regret that this appears to be a very basic  question, but I
am fairly new to the ORACLE world, and cannot find the resolution
to my question in any of the MASS of documentation.  

As one user, I have create 2 tables and a form which accesses them.
As that user the form works. Using SQL*PLUS and the 'Grant all privileges '
command, I have given a second user access to all tables; and  can  verify 
access via SQL*PLUS.  However, if the second user attempts to run the
form and query the database,  I the message: 
ORACLE error occurred while trying to perform query.

Comparable messages occur if I attempt to update.

I've obvously missed the boat on some table that needs to be updated,
but I cannot find any reference.  

(I'm using a system V based platform, not that it should matter.)

Any good Oracle book references would also be appreciated. 

Much thanks.

Please respond to me at uunet:   modcomp!glsdev!angel