Sql Server view with very limited access I have a requirement to limit a view in Sql Server 2008 R2 that user:


user has access to select from view.
user has not access to copy the result from select statement.
user has not access to join the view.


I have to use Sql Server view, is it possible?
As soon as someone has access to SELECT from a view, he can also copy the result set and join it with other views or tables, he has access to.

If you need to follow those requirements, you would need to create a custom application, that does not allow copying of data.