Limiting user access to VIEW tables
I am creating a database for staff to report tasks they perform on a daily basis.
I have created a table for each staff member. How do I limit user access so that each user can edit and VIEW data in only their table while still allowing the Admin account to have full access to edit and view all the tables?
The database is on a server so script suggestion should have this compatibility.