Maybe do two things:
1) Compile the trigger to run with "owner authority" ( owner is the ID creating the pgm object )
2) Grant *all for "my work file" to the trigger owner.
Where I work, all objects are owned by a common Group ID so we don't have issues
any pgmr changes an object created by another, or when a person leaves the company.
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
Sent: Monday, August 04, 2014 7:12 AM
To: Midrange Systems Technical Discussion
Subject: Trigger issue with authority
I had a case happen that the trigger would not run.
the trigger is on a physical file which has 2 logicals to it. I have a PF that will be updated when one field in the PF changes.
When change made and trigger is invoked i run a CL program which clears my work file and then rebuilds it via RPGLE program.
that is all the CL does, CLear and run the RPG.
But got an error CPF3137 NO Authority to clear, initialize etc.
Do I need now to change the authority on that Temp file I created? the current is
*PUBLIC * CHANGE
i am also on their with *ALL.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l