how to handle and store the users and access levels

[ii128]

I have over 30 applications and databases. Some of them are VB Applications. Some of them are Access Applications. Each application need to log in bases on User name and then get the access level. They are too many users and access levels for all 30 applications.

Anyone has a good idea on how to handle and store the users and access levels universally?

I have two ideas. any comments on that?
1, Save all users and access levels in one centrol database.
2. Save the users and access levels in each individual database.

 

[scking]

If you use access security you don't have to keep track of usernames and group/user permissions because you can write a few functions to retrieve them. Such As:

Access function CurrentUser returns the name of the user logged on

User developed function HasPermission(CurrentUser, usrWrite) would return a True/False. It would first test if the individual username had the permission and then loop through the inherited group permissions to see if the individual would have the permission as a member of a group.

User developed function IsMemberOfGroup(CurrentUser, GroupName) would return a True/False if a valid groupname was entered in the Groupname parameter.

Steve King

Growth follows a healthy professional curiosity

 

[mac318]

ii128,
Use both of your ideas. Each database should manage its own security and maintain its own log table. These log tables can then update a central log table on the server.

mac