Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting Object Level Security
Message
 
To
21/02/2007 15:58:24
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01197756
Message ID:
01197787
Views:
11
>I am looking for some guidance regarding sophisticated access to controls on a form. Our application must be able to determine if a user will have access to a menu item or form control(s) based on group permissions, individual permissions, etc. I know MM has several security objects, does anyone have any experience with this type of implementation? Do you use a third-party product or have you implemented your own solution? A data-driven solution that would require manually updating seems cumbersome.
>TIA
>Amanda

I normally set a number of application scoped (public) variables when an application opens and set them appropriately..

ie..

public glAdministrativeUser, glDataEntry, glPowerUser, glAddClients ...

&& then set vars to .T. that the user should be in (via NT security or SQL membership, etc)...

set_security(getenv('username'))

Then in menus that require security..

skip for !glAdministrativeUser ...

&& then either disable controls based on security on form init or set when clause base on security variables.

Not pretty but it works.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform