October 26, 2011 at 3:02 pm
When going across databasses, the users have to be given access to the base tables in the other databases. The only way around this is to pull the data into your third database and build the view over those tables.
October 26, 2011 at 3:16 pm
In SQL 2000 I agree with Lynn, there is really nothing you can do but copy the data to a single database. In SQL 2005 you could probably build out a signed sproc that could return the data, have never seen a signed view discussed..
CEWII
October 26, 2011 at 3:32 pm
Wouldn't a distributed partitioned view help achieve that?
Best regards,
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
October 26, 2011 at 4:04 pm
No because you still have to overcome the database level security. And I don't think that it can be overcome with database chaining either.
CEWII
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply