I have a requirement to limit a view in Sql Server 2008 R2 that user:

  1. user has access to select from view.
  2. user has not access to copy the result from select statement.
  3. 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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.