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

You are right Walden, I did not read the original question.  Be more careful
next time.

Christian

ASP-re Inc.

Christian Enriquez
440, René-Lévesque O. suite 203
Montréal,Québec, H2Z 1V7
514-392-0007 ou christian@asp-re.com


Ah, but screen-level security misses the point. IIRC, the original question
dealt with users downloading the file, how does your product prevent that
level of access? You could, of course, revoke everyone's access to the files
and only access the file through programs that adopt, but most system
weren't designed for that.

As far as the trigger idea goes, I think in this case I'd replace the values
with "Protected by FERPA" or something to that effect rather than *LOVAL.
That way users know there is data, but they aren't allowed to see it. Of
course if you implement this read trigger how will the programs that ARE
allowed access to the data see it? You'll need some way of saying "This job
is allowed access", perhaps a dataarea in QTEMP, or a Job Switch (gulp!<G>)
or ?????

-Walden


------------
Walden H Leverich III
President
Tech Software
(516)627-3800 x11
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com

_______________________________________________
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.