RE: New Idea about Rpg program, copy members and RDI

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-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> On Behalf Of Michael
Quigley
Sent: Thursday, December 11, 2025 4:29 PM
To: [email protected]
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: [email protected]
> 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-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> On Behalf Of 
> Michael Quigley
> Sent: Thursday, December 11, 2025 10:21 AM
> To: [email protected]
> 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: [email protected] To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related
questions.


-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.