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: 397721
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply