Colin,
Have you thought of just controlling the display of the fields in the notes records?
Do people in your office always work from their own computers? Or do they have
separate password/group logins? If either of those are true, you can capture a value
for creator of the note record, and then replace the Notes::Note/Task field in the
Notes History layout with something like the following:
DispNoteTask (calc, unstored) =
If ( Status (CurrentUserName) = AddedBy , Note/Task , "Access Denied" )
Of course, this wouldn't prevent someone from going to the actual Notes_.102 file and
flipping through records, but you could potentially prevent that by mucking around
with the navigation scripts.
Do you need users to be able to execute finds on Notes records? If not, this whole
thing would be easier.
The thing to realize is that it's really hard (almost impossible) in FMP to prevent a
user from seeing particular records as opposed to others. Easier to control the
display of particular fields.
HTH,
Matt Scholtz
At 12:32 AM 11/6/00 -0500, you wrote:
>My reading of the FileMaker manual says that the permission system is
>capable of doing that, but it sure sounds like a pain to do. Just
>restricting all but a few users from the notes as a whole should not be so
>hard as it can be done via the groups.
>
>It all really boils down to how much you trust the ability of staff to keep
>things confidential. For instance there is nothing you can do to prevent
>someone with the master password from seeing everything. Just telling him
>this may make him realize how silly really strong protection is and not
>worth the trouble. If stuff is that sensitive, perhaps it should only exist
>on paper in locked file cabinets - or better yet left to the memory of those
>with a need to know.
>
>Hopefully the V2 staff do a better job of separating the data into files and
>layouts with different protection attributes, e.g. don't make all the
>financial summaries visible on the home page when only the development staff
>needs to see these.
>
>> -----Original Message-----
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Colin
>> Cooler
>> Sent: Sunday, November 05, 2000 10:48 PM
>> To: ebase-Support
>> Subject: [SUPPORT] Making "Notes" Private
>>
>>
>> The CEO has thrown me a curve!
>>
>> It now seems that, instead of allowing everyone who can access the ebase
>> database and being able to see the "Notes" for any record, he
>> wants each of
>> the four users to be able to only view the notes that he/she created. It
>> seems they are of somewhat confidential nature. Is there any conceivable
>> way this could be done within ebase?
>>
>> Or should I try to somehow create more (sigh) external files
>> (which would be
>> linked to ebase via "Record Number")? If so, do you have any thoughts on
>> how this might be done?
>>
>> Any advice appreciated at this late stage!
>>
>> Colin
>>
>>
>>
>
>
>
Matthew Scholtz
Evaluator and IS Coordinator
Health Initiatives For Youth (HIFY)
www.hify.com
