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
精彩评论