开发者

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

开发者 https://www.devze.com 2023-01-21 06:39 出处:网络
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.

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

精彩评论

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