RE: ODBC problem (I think)

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