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

The easiest way that I can think of is to create a logical file excluding
FERPA records and only give access to the logical file.

Albert York


        -----Original Message-----
        From:   Booth Martin [SMTP:booth@MartinVT.com]
        Sent:   Wednesday, January 23, 2002 9:21 AM
        To:     midrange-l@midrange.com
        Subject:        Use of a trigger...?  is this areasonable?



        I've just been handed a problem and first blush tells me that a
trigger is
        the answer, but I sure would like to hear comments from people on
the list
        that have already dealt with this sort of problem.

        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)



        --------------------------------------------
        Booth Martin
        MartinB@Goddard.edu
        802-454-8315 x235
        --------------------------------------------
        _______________________________________________
        This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list
        To post a message email: MIDRANGE-L@midrange.com
        To subscribe, unsubscribe, or change list options,
        visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
        or email: MIDRANGE-L-request@midrange.com
        Before posting, please take a moment to review the archives
        at http://archive.midrange.com/midrange-l.