Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!cs.utexas.edu!uunet!mcsun!ukc!warwick!nott-cs!lut.ac.uk!elaps From: elaps@lut.ac.uk (Alan Schwarzenberger) Newsgroups: comp.databases Subject: Re: operator access to SQL*FORMS 2.3 (RDBMS 6.0) Message-ID: <1991Jun24.085125.9399@lut.ac.uk> Date: 24 Jun 91 08:51:25 GMT References: Organization: Loughborough University, UK. Lines: 17 In angel@modcomp.uucp (Pam Angel) writes: >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. I assume that you are accessing the table as TABLENAME rather than USER.TABLENAME - for example if OPS$FRED owns the tables, OPS$JOE has to access them as OPS$FRED.TABLENAME -- ============================================================================ Alan Schwarzenberger tel +44 509 222849 A.P.Schwarzenberger@lut.ac.uk International Electronics Reliability Institute, Loughborough University, UK