How to give access to a user on only two specified procedures and specified tables on SQL Server?
Bu default, a user don't have any premissions. So, all you have to do is to grant the permissions you want:
GRANT EXEC ON proname TO usrname
GRANT SELECT ON tablename TO username

I don't understand what you mean by &quot;tables to be fed&quot;.
If a proc operates on a table (SELECT, INSERT ...) then it is enough to have EXEC permissions on the proc, you don't need the (SELECT, INSERT...) privilege on the table in order to execute the proc. This assumes the same over of the proc as the table, called &quot;ownership chaining&quot;.