Re: ODBC problem (I think)

Do you have an exit program on the ODBC-related exit points?

ODBC Exit points:
QIBM_QZDA_INIT called at server initiationQIBM_QZDA_NDB1 called for native
database requestsQIBM_QZDA_SQL1 called for SQL requestsQIBM_QZDA_SQL2
called for SQL requestsQIBM_QZDA_ROI1 called for retrieving object
information requests and SQL catalog functions



Gary Monnier
*ATI Administrator*
*425.427.7959*

On Fri, Jul 13, 2018 at 8:24 AM, Denis Robitaille <
denis_robitaille@xxxxxxxxxxxx> wrote:

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.
midrange.com_mailman_listinfo_midrange-2Dl&d=DwIGaQ&c=
pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=
IZErN92WNgnaOdLlLAkjFW4ZBEINyb5VpdtaTlqoR8s&s=gkFEoJguT-
bB8JJFwKGzLJbR4IGWhirw3P5jDpJ6_EY&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://urldefense.proofpoint.com/v2/url?u=https-3A__
archive.midrange.com_midrange-2Dl&d=DwIGaQ&c=pApUd0AUA6FmKRo01iR_VA&r=
r7w16KGEqE6t2tVCvCsz4_ztz5b0wbCtdhwrG0PzYq8&m=
IZErN92WNgnaOdLlLAkjFW4ZBEINyb5VpdtaTlqoR8s&s=
NiJhgcDah7TcUT673PWccsuJgs3Yufm0TXEgUhnxrdc&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_
2dEadiD&d=DwIGaQ&c=pApUd0AUA6FmKRo01iR_VA&r=r7w16KGEqE6t2tVCvCsz4_
ztz5b0wbCtdhwrG0PzYq8&m=IZErN92WNgnaOdLlLAkjFW4ZBEINyb5VpdtaTlqoR8s&s=
4qf3r42GFLES4N_d_cDtmy24BD75_Kdu7J0jfskBSeY&e=