Hello Roy

Just speaking for myself I don't believe in framework because it is never 100% compliant with every program you might make.

But with security I do 3 basic things ;

First in the “users” table I create logical fields to grant or deny access and I create 1 numeric field for detailed access level.

Logical fields for basic security (security to forms and command buttons) and the numeric field is for access to the vital form textboxes (I create a textbox (checkbox, listbox, memobox, grid, ect…) class with a custom property with zero “0” as the default then just check access value against textbox property)

Second on a successful login just store the values (and labels for the values) in a array then just check array values when needed.

Also you can setup static or dynamic groups in you system that will “hand out” default access levels to simplify adding new users

if you need a sample I can send you some code and email some objects, it really is a simple expandable way to integrate security into your system, I am sure other people have better ways

hope I helped





>Hi,
>
>I'm looking to add security/rights for my application. Basically a user logs in to the app and they get access to screens, reports, read/write/ etc,etc.
>
>I have a simple security framework but difference with this app is that the way that the requirements are changing here it seems that I might need to make this security framework work very low level, meaning not just groups but also give individual users rights to different objects in a form apart from the read/write access.
>
>I guess I have 2 options, one to get an established security framework (if there's one out there) or build one myself. Another issue is if I write one myself, does anybody know of a good method to accomplish a very customatizable and detailed security framework?
>
>Thanks