× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hello,

I checked that audit journal. I fount GR, JS and ZC transactions. Nothing unsual in them

The QZDASOINIT joblog did not show anything special either.

And just to let you know, the user I used has *ALLOBJ *SECADM *IOSYSCFG *JOBCTL *SAVSYS *SECADM *SERVICE *SPLCTL special authority. So it should have access to everything.

-----Message d'origine-----
De : MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> De la part de Bryan Dietz
Envoyé : 13 juillet 2018 10:52
À : Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Objet : Re: ODBC problem (I think)

have you checked the audit journal to see if there is anything else that the user might not be authorized to?

were you able to find the joblog of the QZDASOINIT job to see if anything in there was interesting?

Bryan



Denis Robitaille wrote on 7/13/2018 9:37 AM:
Hello all,

I am faced with a situation that I can not understand.

We have an excel spreadsheet that do a qwery on an Iseries. With some users it works fine, with other we get the following error:

[IBM][ODBC System i Access Driver][DB2 for i5/OS]SQL0551 - Not
authorized to object QZDA07600X in QGPL, type *SQLPKG]

With my user, it works fine so I cloned it. With the clone, I still get the error. The clone as *ALLOBJ but still gets the error.

I even deleted the QZDA07600X SKLPKG since it would get recreated by the system if necessary. I still get the error even if the object do not exist!!!!

I am out of idea.

Here is what I think are the key information:
We are at 7.2

Here is the connection string:
DRIVER={iSeries Access ODBC driver}; XDYNAMIC=0;
PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;
LANGUAGEID=ENU;DFTPKGLIB=QGPL;DBQ=QGPL CDTAWHSE;
SYSTEM=cas800re.cascades.com;

The query is a simple SELECT from a single file

Any help would be appreciated



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2024 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.