× 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 all,

I have a stored procedure on an iSeries that I created. I'm trying to fire that SP from a VB6 program (Don't ask), using the Microsoft OLE DB Provider for DB2. When I log into the application using my user id, I'm getting an error that I don't have authority to "something". The message is not very clear as to what I don't have access. I know I have authority to the program behind the procedure. I'm the owner and it has *public *all. I'm thinking it's one of the underlying programs or files that tells the iSeries how to convert a SP to a program, for lack of a better explanation.

I can find the QRWTSRVR job that is servicing the request. When the admin gives me *allobj authority (I'm a consultant here), the procedure works fine and I can see the results of the job in the joblog of the QRWTSRVR job. But, that joblog gives me no clue as to what I don't have access.

Any ideas on how I can lock this down?

Thanks,

Mark Walter

Business to Business Data Integration Specialist
Certified IBM System i Specialist
Paragon Consulting Services, Inc.
mwalter@xxxxxxxxxxxxxxx<mailto:mwalter@xxxxxxxxxxxxxxx>
717-764-7909 ext. 20


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-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.