Looking for Good Password Maintenance Code

[GummowN]

I am updating our system to include user level security. I already have a structure in place having upgraded the system to check for group membership on a number of key areas but instead of reinventing the wheel I was hoping someone may feel generous with their code.

We have a security structure of 5 levels, 1 - Basic to 5 - God.
Level 5 is the only level that can add/delete users and change all users passwords
Level 4 and below should be able to change their own password but also add users at a level equal to or below them.

All help/advice is welcome

 

[Darrylles]

Hiya,

You make it sound like you have upgraded your security on a number of key areas.

You don't specify which key areas you have got covered.

Your text implies you're covered (you already have a structure in place).

Does "We have a security structure of 5 levels" actually mean that you REQUIRE a structure of 5 levels or that you've PLANNED it and want to implement it?

Help me.

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[GummowN]

Throughout the system we use a:

Select case getuaccess()

where getuaccess() is a function that returns the users group.

The main requests are:

Code to change password
Code to add user only at a level equal to or below the currentuser
Code to add/delete a user for a user at level 5

Does that help?

 

[Darrylles]

Hi,

Thnx, seems you have the skeleton in place and now it requires the meat.

Just to make sure, you are aware that Access has a good security system where you can control access rights from application level right down to field level, with different levels of access per user or groups etc?

If not - search your system for 'WRKGADMN' (it's in the MSOFFICE directory). Run it and you can exclude and include to your hearts content.

You'll need to start a new thread for help on this, I'm no expert on it.

If you insist on writing you're own 'security' into an application - no prob. - just post a reply.

Regards,

Darrylle



"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."