Home Forums SQL Server 2008 SQL Server 2008 - General user permissions to only for view RE: user permissions to only for view
Koen Verbeeck
SSC Guru
Points: 259085
More actions
October 9, 2013 at 1:15 am
#1657008
You should give the user only SELECT permission on the view.
GRANT SELECT ON viewname TO username;
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP