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 |
|
vwong007
Starting Member
1 Post |
 Posted - 2009-07-30 : 07:36:58
|
| Hi all,Here is my setup. I've got Database1 that has DBUser1. I've got Database2 that has DBUser2. In Database1, I have a view that references a table in Database2. The problem is that DBUser1 doesn't have access to Database2, so I get a permissions error."The server principal "DBUser1" is not able to access the database "Database2" under the current security context."Normally, I'd just add DBUser1 as a user on Database2, which is how we have it setup locally. But on production, we are in a cloud and database users are not allowed to share databases.Is there any workaround? Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-30 : 14:31:09
|
| then you need to set up linked server b/w dbs and then use mapped logins |
 |
|
|
|
|
|
Need help with a view