Your technology certification is waiting. Enroll in Cloud Class ®
CREATE USER yourUserName FROM LOGIN yourLoginName;
GRANT SELECT ON Schema.YourViewName1 TO yourUserName
GRANT SELECT ON Schema.YourViewName2 TO yourUserName
Open in new window
Your question, your audience. Choose who sees your identity—and your question—with question security.
My loggin is sa
CREATE LOGIN LoginNameHere WITH PASSWORD = 'PasswordHere>'
CREATE USER UserNameHere FOR LOGIN LoginNameHere WITH DEFAULT_SCHEMA=[dbo]
GRANT SELECT ON ViewName1, ViewName2 TO UserNameHere
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!