>A client of mine wants me to upscale an application I developed to an SQL back end. He wants to be able to incorporate the network login security information from their intranet to control what records and modules are available to the user based on their security level. From thread #463260 it looks like one can control record access using SQL security, but what about modules or menu items? As I am not very familiar with SQL (yet), I am interested to know the possibilities.
>
>Thanks in advance for your help.
>
>JR

Basically you have to write your own security module that contains a list of users and the secured things. Then create a junction table that holds all the available items (or only the items not available) for each user. You can store the information on the SQL Server backend so no one can tamper with it in VFP tables. Several (if not all) of the commercial frameworks have this functionality. You can try to download an evaulation copy and see how they did it.

HTH.