AnsweredAssumed Answered

Limiting user access to VIEW tables

Question asked by PollyRyan on Mar 27, 2013
Latest reply on Mar 28, 2013 by PollyRyan


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.