field level security - (Was Use of a trigger...? ....)

Rob,

Like I said, I had never used field level security, nor seen it used.  only
heard it was available.  Just throwing it out there as a possibility.

so, you're saying that all traditional means of getting data from the file
would have a hard error trying to access that field without authority?

that's an elegant solution.....
not.

rick

--original message--

Richard,

Think of it this way.  You have a traditional RPG program.  You loathe
selecting fields with logical files or SQL.  Now you read a file which
contains a field of which you are not authorized to - by the way it is this
field for every record.  Therefore every read will be an error.  The
workaround is to either create a view or logical file which omits these
secured fields, or avoid traditional RPG i/o and use SQL to
if superuser;