That is another possibility. I do a lot of multi-machine work where I reach
from one machine to the other so I do a CONNECT to the machine and then do
an SQL EXEC to run the command.

Who knows what I was doing when I had the issue. Like many, I found a work
around and stuck with it rather than spending the time that I didn't have
back then to figure out why it didn't work to fix it.


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Michael
Quigley
Sent: Thursday, December 11, 2025 4:29 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: RE: New Idea about Rpg program, copy members and RDI

I would be interested in what the circumstances were. I tested it with the
service program in a different activation group. It still uses the adopted
authority of the caller. Now if it's SQL, there may be some additional
things that need to be handled to use the adopted authority. I would have to
refresh my memory on those details...

Thanks,
Michael Quigley
Computer Services
www.TheWay.org

-----Original Message-----
message: 5
date: Thu, 11 Dec 2025 16:18:22 -0500
from: smith5646midrange@xxxxxxxxx
subject: RE: New Idea about Rpg program, copy members and RDI

It has been a while but I'm going to guess they were not in the same
activation group and that was my problem. If you still have your test
program handy, can you test again with different activation groups?
If you've already cleaned it up, I will try it later.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Michael Quigley
Sent: Thursday, December 11, 2025 10:21 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: RE: New Idea about Rpg program, copy members and RDI

Service programs already use adopted authority from the calling program.
The only difference is I don't believe you can tell a service program
to not use adopted authority like you can on a program. I thought this
was true, but was puzzled by your comment that you couldn't figure out
how to do it. So I wrote a quick test creating a file with *PUBLIC
*EXCLUDE, writing a quick module to display the object description,
creating a service program with that module, and then creating a
program with USRPRF(*OWNER) and owned by a profile with *ALLOBJ
authority. If I try to display the object description of the test file
from a command line, I get the CPF2189 escape message "Not authorized
to object...." But if I call the *OWNER program, the module does the
DSPOBJD and works fine.

This makes sense to me because the service program is running in the
calling program's activation. It doesn't have it's own.

Thanks,
Michael Quigley
Computer Services
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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