Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rsn1966
Starting Member
9 Posts |
 Posted - 2010-04-28 : 14:03:28
|
| I am learning SQL Server 2005 and I am trying to learn how to setup up permissions for a login. What I would like to do is give a user (login) read only access to a single view that I created. I do not want this user to access any other views, tables, or anything else other than that one view. I thought that by creating a role that gave select permission to the view and then assigning the user to that role would work; but, it isn't working. Can anyone give me an idea on how to execute this? Is there a tutorial that can explain how to administer right to tables, views, etc.? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rsn1966
Starting Member
9 Posts |
Posted - 2010-04-28 : 16:12:09
|
| After some of my own testing, creating a custom role does work in restricting access to the view. I ran a few tests using a test login which confirmed that the role was working as it should. Would a problem occur if a user was accessing the view through an application like SAS? One person is using SAS to access the SQL Server. A ODBC data source was setup on the person's PC and I check it using Access to see if I can see the view. It just might be a SAS issue and not an issue with how I set up SQL Server.Thanks for your help. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Login Security and Permissions