开发者

Restrict access to certain rows in table based on user

In SQL Server, how do 开发者_JS百科I restrict access to certain rows (hide data) in tables based on the users identity?


The basic / normal way to do this would be:

  • prevent that user (or group) from accessing the base table
  • define a view on top of that table that shows only the rows these users are supposed to see
  • give those users SELECT permission on the view
0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜