MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2014

RE: Trigger issue with authority



fixed

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.

-----Original Message-----
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,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact