Grant Permission to View MS SQL Server

First you should create user and assign public server role for releated database.



GRANT SELECT ON [DBNAME].[SCHEMAName].[ViewName] TO Username

Example;

GRANT SELECT ON [YNS].[dbo].[V_Personnel] TO ViewUser1