Problem with runrep
Date: 17 Feb 1994 19:24:27 GMT
Message-ID: <clement1-170294101757_at_attilla.llnl.gov>
I wonder if anyone can help me with the following oddity. The problem is a HOST('runrep'). If I run the form, HOST('runrep. . . .') works normally and the report prints as one would expect. If any other user runs the form, HOST('runrep. . . .') fires and the "Working. . ." message from runrep appears, and then the user gets "ORA-00942: table or view does not exist."
This error only occurs within the form. Any user may run the report by entering the runrep command, with identical parameters, at the shell prompt. Any user may (somewhat tediously) duplicate the report by entering SQL*Plus and typing in the queries.
Vital statistics: SQL*ReportWriter 1.1.14.9.1; SQL*Forms 3.0.16.12.7; ORACLE 7 Server 7.0.15.4.0 with procedural and distributed options; SunOS 4.1.2 running on Sun4.
Additional background:
I wrote the form and the report. Users access this form by
doing a runform30 from inside a menu, with user ID set to /
(that is, we're using the OPS$ IDs), and in the argument to
HOST the userid parameter for runrep is also /. The tables
queried in the report are accessible through a user role
that grants SELECT on all these tables, and all users I am
concerned with have this role. Since there are several
developers, report access is PUBLIC. In the course of porting
code developed under ORACLE version 6 to the present
environment, I moved the report with dumprep and loadrep.
So far as I can tell from the user privileges visible to me,
srw_grnt.sql was run at the installation of SQL*ReportWriter.
The SRW tables are system-owned, not user-owned.
David Clement || Geyr nu Garmr mjok fyr Gnipahelli. clement1_at_llnl.gov || Festr mun slitna, enn freki renna.
Received on Thu Feb 17 1994 - 20:24:27 CET