Re: Program user profile, adopted authority, and named activation groups

On Mon, Nov 10, 2025 at 4:54 PM David Gibbs via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

On Mon, Nov 10, 2025 at 3:47 PM Rob Williams via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Is the procedure in the Service Program using SQL? And if yes is the SQL
procedure using a Dynamic SQL statement? If yes, adopted authority may

not

apply.

The service program is using SQL, and some of it is dynamic SQL, but not
the specific procedure

The SQL in this service program has been in place for years and hasn't
caused a problem.

The change that we recently deployed had nothing to do with the table that
we're having the authority issue with (as far as I can tell).

david

--
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding in the American Diabetes Association's Tour de Cure to raise
money for diabetes research, education, advocacy, and awareness. You can
make a tax-deductible donation to my ride by visiting
https://mideml.diabetessucks.net.

I may have diabetes, but diabetes doesn't have me!
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.