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 |
|
JClaud
Starting Member
3 Posts |
 Posted - 2011-10-05 : 03:13:16
|
| HiI have an Output database for a specific purpose. In this database I have view that select data from another more generell database.How can I set up a Login that can be used to select from the views in the output database, without the login having read access to the generell database?Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-05 : 04:12:38
|
| is it indexed view? if not login has to have read access to underlying object in other databse for it to pull data through the view------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
JClaud
Starting Member
3 Posts |
Posted - 2011-10-05 : 05:24:48
|
| ok, i will have to use stored procedures instead |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-05 : 05:41:24
|
| then also permission should be provided for login in 2nd db for accessing object.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
JClaud
Starting Member
3 Posts |
Posted - 2011-10-05 : 07:06:26
|
| ok, is it any other way to achieve this?I don't want the login to see the complet tablen, and only access the information with some filters Thanks! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-10-05 : 07:11:41
|
| Can you set up the Sproc to impersonate a user (who does have access to the other database)? ( I don;t know the answer as I haven't tried using Impersonation at all!) |
|
|
|
|
|
|
View with data from another database