Using SQL Server management studio: In the object explorer window, right click on the view and click on Properties. Navigate to the Permissions tab. Here you can see the list of users or roles who has access to the view. Also, you can see the type of access the user or role has.
How do I check SQL database Permissions?
Open and login to Microsoft SQL Server Management Studio. From the Object Explorer in Microsoft SQL Server Management Studio, right-click the desired Database and select Properties. Navigate to the Permissions page and select the desired User from the Users or roles list.
How do I grant permission to view SQL?
For the existing view, you can go to the Properties of the view in SSMS, add users in the Permissions, and then grant select permission in the permissions list. Or use the following statement to grant user permissions: GRANT SELECT ON OBJECT::[schema]. [yourview] TO User1,User2.
