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
tblApprovedUsers
UserID
UserName

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
DbLoginID
DbLogin
DbPassword

tblUsers - This tbl stores all Users with Approved access to DB
UserID
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.
UserAccessID
UserID
TableName
RequiredPwrd - Yes/No

I appreciate your input. Thanks in advance

Kh,

If you just want the ability for Log-on/off, take a look at the SecurityDemo2000
attached on this link:

Link to Attached SecurityDemo2000

Good luck with your project,

Aqua