I want to share with you my own interpretation for a Login And Permission System.
I was inspired by the principles of the UNIX operating system: execute, read, write and delete to which I added: export, import and print.
Obviously they were my needs
The system is based on two text files: one (logins.ini) stores the information to perform a login with password in the other (permissions.ini) stores the permissions granted to users.
Below I give a brief description of their contents; you can find it in the files and sources.
1) logins.ini
- each line refers to a user only, the fields are separated by ";"
- Each line must contain five fields:
# 1: access login or username or user ID
# 2: full name or description
# 3: activation date in the format yyyymmdd
# 4: from the date the number of days of validity (0 corresponds to infinity).
# 5: password, encrypted using the HB_CRYPT() function
2) permissions.ini
- each line refers to only one user for every application and function, the fields are separated by ";"
- Each line must contain four fields:
# 1: application Name. NB the idea is to handle multiple applications (not functions / procedures see below)
# 2: function name (or precedure) associated with the application and user related
# 3: access login or username or user ID (See #1 logins.ini)
# 4: permission granted. It's a string (currently) can contain these symbols:
X = execute, R = read, W = write, D = delete, P = print, I = import, E = export
If all permits are granted, alternatively use "all"
I preferred the text file to make changes quickly using any text editor.
Obviously, you can not use the text editor to modify encrypted passwords: you must use a function.
In a network environment, the two files could be located in a read-only folder (the passwords are encrypted
)I wrote two programs: the first (l3wsetup) create two sample files, the second (l3wtest) simulates the use in an application.
Well, that's all.
I hope someone finds this useful solution. I'm available for questions and comments.
Oh! I forgot. You can freely use all materials except the logo L3W: is mine
Best regards
