>I am conducting some research re: security for VFP 3.0
>users. My Information Services department will be
>working on 3 levels of security - Development, Testing,
>and Production/User environments.
>
>Can anyone suggest any third party software which would
>allow VFP to utilize a Novell Network security system as
>a 'built-in' security system?
>
>Aside from network security, what other security can be built into applications developed in VFP?
>
>Any help in any of these areas would be greatly appreciated.
>
>Thank You!
In the past I have setup the following security using a VFP table.
1.) Table level per user with read, update and create flags.
[Table Name, User ID, Read_Flag, Update_Flag, Delete_Flag, ...]
2.) Report level per user. Only certain users could access certain reports. [Report Name, User_ID]
3.) Report output options. Such as Preview, Print, Copy to ASCII/Excel. Some users only had the Preview option. This was setup by a user group level within my VFP table.
4.) Data Entry for toolbar options. Add, Find, Sort, Edit, Delete, Archive, Copy, ...etc. were setup by User group level.
I did not encrypt any of these tables. But, my thought in the future was to take a snap-shot and develop a checksum that could be used to determine if any changes were made and reset the table somehow. Anyway, my client is presently not concerned with that level of security. The only encryption I do have is in the User table. I developed a unique key and used TRANSFORM() to convert strings. It is a real basic technique and meets the clients needs. Well, htwh. Steve
Steve Medvid
Systems Analyst
Environmental Resource Management