RE: Use of a trigger...? is this areasonable?

["Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>]

Am I crazy, or didn't I hear something about "field level security" being a
new feature on the 400 several years ago?   I've never used it, never seen
it used and I heard it had a fairly significant performance hit.

if true though, couldn't that be used for your ferpa problem?

ok, maybe i am crazy...

rick


---original message---
This is an existing application with lots of existing programs and queries.
The records are (and should be) available for totaling, counts, reports,
and
internal use.  FERPA has to do with releasing private information to the
public.  Creating the new logicals is a solution of sorts but creates many
problems with day to day use of the data.

The issue isn't so much security as it is "appropriate use".  Some sort of
as-yet undefined business-rule process has to take place.  There are people
already working on solving the business rule problem but my task is to
implement the business rule once they've written the rules.  It appears to
me that I have to find some way to attach the business rules to the data
itself, not overlay a simplistic mask on the data.  A logical view solution
seems easy to implement but impossible to live with.

Thank you all for this discussion.  Its being very helpful to us here.