SQL Sever create a user with rights only to view a particular View or to execute only a particular stored procedure. CREATE LOGIN user1 WITH PASSWORD = 'abc@123' GO CREATE USER user1 GO CREATE ROLE AccessMonitoringViewRole ; GO EXECUTE sp_addrolemember AccessMonitoringViewRole , user1 GO --GRANT EXECUTE ON dbo.sproc1 TO execRole --this line is for granting execute on stored procedure --below line is for granting view on a view GRANT SELECT ON [dbo] . [vAccessMonitoringView] TO AccessMonitoringViewRole GO