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

Note CPF5134 talks about data authority and not object authority. Does the program owner adopting authority have *READ, *ADD, *UPD, and *DLT authority to the table getting the authority error.

Specific authority is required to both the View (LF) and Table (PF).

Have you looked at the Audit Journal to verify the actual table having the authority issue?

Rob W.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of David Gibbs via MIDRANGE-L
Sent: Monday, November 10, 2025 1:55 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: David Gibbs <david@xxxxxxxxxxxx>
Subject: Re: Program user profile, adopted authority, and named activation groups

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