Re: ODBC problem (I think)

[Bryan Dietz <bdietz400@xxxxxxxxx>]

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
>
>
> [cid:image001.jpg@01D1F7D9.2487F9B0]<http://www.cascades.com/_home>
>
> Denis Robitaille
> Chef de service TI - Solution d'entreprise
> Infrastructure et opérations
>
> CASCADES CENTRE DES TECHNOLOGIES
> 412 Marie Victorin
> Kingsey falls(Québec) Canada J0A 1B0
> Tél :  819 363 6100  Poste :52130
> Cell : 819 352 9362