Set up user to have only access to one view

I am trying to set up an user to have access to only one view.  Is there a way to take all rights to all the database and table and give the right to the view only?  I would like to do this with the user login screen in SQL server Management Studio.  

Thanks
DowneyCityAsked:
Who is Participating?
 
lluddenConnect With a Mentor Commented:
Create a user in the database.
CREATE USER [MyLimitedUser] FOR LOGIN [MyLimitedUser] WITH DEFAULT_SCHEMA=[MyLimitedUser]
GRANT SELECT ON [dbo].[myView] TO [MyLimitedUser]

You can do this through the GUI also.
0
 
zvytasCommented:
Yes, it is possible. Simply create new user with no right at all and grant select permission on the view in question:

GRANT SELECT ON <view> TO <user>
0
 
DowneyCityAuthor Commented:
Understand the sql statement but would of like to see it done with the GUI.  Was able to figure it out from the statement.

thanks
0
Question has a verified solution.

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.

All Courses

From novice to tech pro — start learning today.