Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Structure tables for save users and permissions...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00626536
Message ID:
00626548
Vues:
11
>I've already it implemented but i'd like to read more opinions about it.
>
>* I use this structure to save users:
>USERS.DBF
>   Username
>   Password
>* and this for save permissions
>PERMISSIONS.DBF
>   Id
>   Username
>   OptionD
>   OptionU
>
>In table USERS I save just the name and the password for each person who will acess the application.
>I have a relation (USERS 1 .. N PERMISSIONS) where I define what is the options and if it can be used (or not) for the Username.
>For example:
>Field OptionD - I store something like that:
>
>INSERT_CUSTOMERS: Can username include new customers? (S/N)
>ALTER_CUSTOMERS: Can username alter customer's data ? (S/N)
>DELETE_CUSTOMERS: Can username delete customer's data ? (S/N)
>and so on...
>
>I hope you understand my way to save user and acess. I'd like to know some other solution about it.
>
>Thanks in advice!

If that fit your needs, this is OK.
But, how do you protect the table from a browse by a user with VFP?
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...


Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform