How to set a permission to let a SQL server user to access for certain tables

Question

I just created two tables and they are named as tblA and tblB. I also created a user(Security/Login) who will be used for a remote insert/update.

What is the best way to permit this user to access for only those two table out of 50 table. I have tried look for the way from (Security/Login) and (Database/Properties). Can I limit it from user account level?

Answer 1

Use a 'grant' statement:

grant select on tblA to the_user_name
grant insert on tblA to the_user_name
grant update  on tblA to the_user_name