Hi all, I’m in need of some advice and best practice!!
In my project an administrator can create a new user and choose between two roles ADMIN & DRIVER (I’m only concerened about the drivers)
The new user with the role (DRIVER) is inserted into the DB (This will now enable the drive to logon) The administrator then navigates to another page where they add a new driver to a DB table UserId Email Name
All the above works just fine. What I wish to do next is when the driver logs in I only want him to see jobs associated with his UserID
If say there are 5 drivers I don’t want them to see each others jobs.
So my question is: What would be the best way to achieve this? Do I need to do a JOIN from my Drivers TABLE To my MEMBERSHIP TABLE? and then grab the users UserID on login?
Any advice would be most appreciated.
Thanks
Go to the complete details ...