Re: Allowing CLRPFM with Limitied Capabilities

No, the limitation LMTCPB does not affect the ability to run that command, 
unless they are typing it themselves at the command line.

What limits them is that they cannot simply have *CHANGE authority to the 
file.  They have to have *ALL.  Not *ALLOBJ, just *ALL to the file. 
Personally I think it is a stupid requirement.  I can easily run a sql 
statement
DELETE FROM MYFILE
which will delete every record, but I can't run any member command like 
CLRPFM.
So, your options include:
- Using SQL instead of CLRPFM.  (Note:  will not remove deleted records 
and free up that space).
- Use a HLL program with the same limitation as above.
- Use adopted authority on a program to some profile with enough authority 
to get the job done.  Must have *ALL access to the file.
- Use profile handles, but unless you have some shop standard to be 
consistent the odds of you doing this versus adopted authority are slim to 
none.
- Grant the user *ALL instead of *CHANGE authority to the file.
- Give the user *ALLOBJ (but then there will be a line of people waiting 
at COMMON to "pants" you for your stupidity).  :-)

Rob Berendt