Grant View

• AntonyO

  Mr or Mrs. 500

  Points: 522

  More actions

  January 7, 2021 at 9:57 am

  #3828489

  I would like to grant a user to see a view but I don't want the user has the access of the tables of the view. Is it possible?

  Thank you

   

   

   

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  January 7, 2021 at 2:14 pm

  #3828561

  Yes. Just grant them read access to the view. Here's the documentation and examples.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning