I am looking to setup some tables for storing DB logins and Passwords, users, override passwords, and table permissions.
I have 2 options
Opt. 1 Use ULS and have 1 table
This gives access to the DB and sensitive data only to users in the list. It also allows a non-developer Admin to
maintain which users have access to the DB.
Opt. 2 Use ULS and have 3 tables
tblDBLogins - This tbl stores all logins into DB and associated Pwrds
tblUsers - This tbl stores all Users with Approved access to DB
UserName - equal to computer logon...Environ("username")
Override - additional password for accessing sensitive data
jctUserAccess - This tbl gives each user access to certain tables and determines which tables need additional security
thus requireing an override password.
RequiredPwrd - Yes/No
I appreciate your input. Thanks in advance