开发者

Restrict access to certain rows in table based on user

开发者 https://www.devze.com 2023-02-14 08:33 出处:网络
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:

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

精彩评论

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