Rene Nielsen

Rene Nielsen

  • NA
  • 22
  • 31.5k

User roles when using 2 databases

Mar 8 2012 4:51 AM
Hey i have a 2008 sql server with 2 databases on

Database 1 = db1
Database 2 = db2

on DB1 i have
a user XX with public rights to enter DB1
a View called VW_TempDb1 which collects data from db2.VW_TempDb2
user xx has select rights on VW_TempDb1

on DB2 i have
a view VW_TempDb2 which collects data from Table1 joined on Table2


i need the user to collect data from VW_TempDb1 without having any rights what so ever in Db2 is this possible!!!?!?!?!? 

Please help i tried looking everywhere