Home Forums SQL Server 2008 SQL Server 2008 - General user permissions to only for view RE: user permissions to only for view
John Mitchell-245523
SSC Guru
Points: 148809
More actions
October 9, 2013 at 2:57 am
#1657034
Granting SELECT on a view does exactly that. It doesn't revoke any other permissions that the user already has. Query sys.database_permissions to find out what those permissions are.
John