Implement Role-Based Security for VFP Controls

摘要

Find out how this alternative to level-based security provides greater flexibility for developers and system administrators and simplifies maintenance. Most applications require you to apply security on a control level. You can permit some users to view and edit data, others to only view but not edit data, and prevent others from seeing any data at all. These applications often use a security-level implementation in which users receive a numeric level determining the controls to which they have access. This article presents an alternative role-based approach in which you assign users one or more roles, and a database tracks what roles have access to each control. This approach provides greater flexibility for developers and system administrators. A developer can set up standard security on any control, and the system administrator can adjust the level of security without having to involve the developer. I'll explain the differences between these two approaches.