0

Hi,

I need to create a data-driven log-in form with different permission levels using classic ASP and MS Access. It is intended for a HR Company.

What I'm trying to achieve is something like the following:

Manager - all access/permission

Staff 1 |
Staff 2 | create, edit and delete vacancies
Staff 3 |

User - view and apply for vacancies

I'd like some help to know which is the best way to achieve the scenario above.

Thanks!

2
Contributors
1
Reply
3
Views
7 Years
Discussion Span
Last Post by WebspoonUK
0

Hi,

I need to create a data-driven log-in form with different permission levels using classic ASP and MS Access. It is intended for a HR Company.

What I'm trying to achieve is something like the following:

I'd like some help to know which is the best way to achieve the scenario above.

Thanks!

Create the following tables (and fields) in your DB: -

Users (UserId int identity, Username, Password, Firstname, Surname, Active, etc...)
Permissions (PermissionId int identity, Description, Active, etc...)
User_Permissions (UPID int identity, UserId, PermissionId)

Once you configure the user's permissions, the login form simply needs to authenticate the user via the Users table. Your login script can then set various session variables which you can check in your code to allow/prohibit HR tasks for each user tasks.

Hope this helps.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.