Member Avatar for Trogan

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
  • 109 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by WebspoonUK
Member Avatar for WebspoonUK

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.