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 |
|
rlopez
Starting Member
18 Posts |
 Posted - 2006-08-25 : 13:00:37
|
| I have a DB that contains only a series of views. The views point to tables and other views in several other DBs. I want to allow users to open the views and run SELECT queries on the views. However if I create a user and add them to datareader role it allows them to view the columns of the view, but not view the data because it points to another db. Is there a way that I can create a role that will allow users read only access to the views without granting permission on the other DBs? Basically I only want users to access the data through read only views and nothing else. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-25 : 13:12:10
|
| Why not just provide SELECT access on the view, plus SELECT access on the tables in the other databases? You usually would just have to provide SELECT access on the view and be done with it, but since your views span other databases, you also need to provide access to the tables in the other databases.Tara Kizer |
 |
|
|
rlopez
Starting Member
18 Posts |
Posted - 2006-08-25 : 13:47:51
|
| I could, but I really wanted to conceal the rest of the database. Is there a way to allow access to other tables but not allow someone to view the tabels in the Management Studio? |
|
|
|
|
|
|
Read only access to views