I recently changed one of my CGI programs to use SQL.  Based on my
change, it quit working!  Damn.

The program runs fine when I run it with my user ID and test it with
debug.  When I run it using CGI (User QTMHHTTP), I get the following
error:

Attempt to use permanent system object QSQRXLTR without authority.
Attempt to use permanent system object QSQRLEX without authority.

I also get a message saying I'm not authorized to the file I'm doing my
SELECT on.

Before: QTMHHTTP was authorized to SLS:

FSLS  IF   E           K DISK    ExtFile(wSLS)
F                                     USROPN

C                  EVAL      wSLS = 'LIBRARY/SLS'
C                  OPEN      SLS

After: QTMHHTTP is not authorized to SLS

C/Exec SQL
C+ SELECT.......FROM LIBRARY.SLS........

Running V5R1. Users have little authority, programs have lots.

David Smith
President
Advanced Information Solutions, Inc.
Email:  dsmith@ais400.com
Phone:  517.548.7170




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.