RE: Losing Authority to a file in Batch

["John Earl" <john.earl@xxxxxxxxxxxxx>]

> I always thought it rather strict that a person needs *ALL
> access to a
> file to do CLRPFM, ADDPFM, RMVPFM but *CHANGE is ok to do
> strsql
> delete from myfile

Technically *OBJOPR + *OBJMGT is sufficient for a CLRPFM command (and, I
_believe_ the ADDPFM and RMVPFM commands), *ALL authority is not
required.

But you are right that SQL or your favorite HLL will allow you to
accomplish the same thing - effectively.  I believe that the theory here
is that record level operations would be recorded to your file journal
(assuming that you are journaling your files), and provide a bit more
recovery option.  

Reality is that if someone cleared your DB file (regardless of method
used) you would most likely restore from a backup copy of the file
rather than re-apply journal receivers.


jte


--
John Earl | Chief Technology Officer
The PowerTech Group
19426 68th Ave. S
Seattle, WA 98032
(253) 872-7788 ext. 302
john.earl@xxxxxxxxxxxxx
www.powertech.com 
 

 
This email message and any attachments are intended only for the use of
the intended recipients and may contain information that is privileged
and confidential. If you are not the intended recipient, any
dissemination, distribution, or copying is strictly prohibited. If you
received this email message in error, please immediately notify the
sender by replying to this email message, or by telephone, and delete
the message from your email system.
--