The tutorials available on the security assist support page walk through creating Password encryption and user level authentication.
if you want to create your own database for both user level authentication and password encryption, your database structure would contain 2 tables, the vbasic structure would look like:
users:
userID - Integer, PrimaryKey
userUserLevelID - integer, Foreign Key - relates to userlevel.userLevelID
userEmail - varchar(25) - used as the username column
userPassword - varchar(40) - Password column, needs to allow 40 characters for the SHA1 encryption
you can add other column like userFirstName and userlastName
userlevel:
userLevelID - integer, primary key
userLevel - varchar(25).
if the tutorials are not ending in the simple system you are looking for, perhaps it would be helpful if you described what precisely is the issue you are having. all of the available tutorials ore on the security assist support page.
