开发者

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

I just created two tables and they are named as tblA 开发者_StackOverflow中文版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?


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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜