At 11:20 01/23/2002, Booth Martin wrote:
>Here's the deal:  our name and address file has a field in their for FERPA.
>If its marked then the name can not be listed or generally distributed
>without that person's written permission.   This has worked fine for years
>when we only accessed the information with our RPG programs.
>
>Now though we have users with Query and other methods of accessing the file,
>and these users just ignore the FERPA field.  The results are labelled
>Trouble waitng to happen".
>
>What ways would you folks offer as ways to prevent access to that record if
>FERPA is chosen?  (I'm thinking this is a question all of us are facing
>lately)


Since you are trying to prevent read access to the data, a trigger will not
be helpful. There is no such thing as a "read" trigger, just Insert, Update
and Delete.

Possibly you could use a view that excludes records with the FERPA flag
set, and restrict direct access to the data.


Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall/



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.