grant read, write access on a table

Question

How to grant only read, write access on a table in a database to a user? Is there anything i.e. grant read, write on table to user.

Thanks

 

Answer 1

Try:

GRANT SELECT, UPDATE, INSERT, DELETE ON MyTable TO MyUser

---

Tom
SQL Server MVP
Toronto, ON Canada

Answer 2

Thanks.