• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

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.  

1 Solution
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.
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>
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.

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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now