i have a database ,i want to make it accessible to 3 type of users(admin,applicant,official) with different permissions ....
how can i resolve,what i modifications it gonna need like to table , relations etc
HunainHafeez 9 Posting Whiz
lena1990 -3 Junior Poster in Training
could you specify more about your program so i can help you ? do you have a server to accept request?
HunainHafeez 9 Posting Whiz
@lena1990: hi, i m working on an online project...... Job portal.....where applicant can apply for different jobs and admin put details regarding vacancies, advertisment etc ....so i want to differentiate between them, so how can i do this in Database, via script ?
HunainHafeez 9 Posting Whiz
plz help me out !!! its very very urgent
seslie 56 Light Poster
Hello HunainHafeez,
please see this link http://www.daniweb.com/web-development/databases/threads/430095/user-roles
Regards
JorgeM 958 Problem Solver Team Colleague Featured Poster
It sounds to me like the classification of your user accessing the application should not be a database role, but an application role where you store the role itself as a field in your datatabase table.
HunainHafeez 9 Posting Whiz
@sesli....So nyc of u ....thanks !!!
HunainHafeez 9 Posting Whiz
@Jorgem, dear , i vl try it too if other solutions failed
Thanks !!! :)
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.