Click here to Skip to main content
15,747,059 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi, i'm doin a approval project. i give a little bit briefing about my project. A requestor request to approve a application. the manager and security need to approve that request. actuall i do know how to code for the pending, approve and reject button. can someone help me to solve this problem. tq
Posted

1 solution

So you need to maintain role type for each user type.

You can define a Role table with RoleId and RoleName. Here you define the name such as "Requestor", "Manager" and "Security".

The id can be mapped by directly having one new column Role in Users table, which will store the RoleId from Role table or having another table UserRoles with UserId and RoleId columns.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900