User roles when using 2 databases
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