Cross-Database Access -> Security?

[murratore]

Hi there....

I've the following problem:
2 Databases for 2 different application. From Application A should be a possibility to read from Database B. I realised this with creating an view in Database A which points on an table in Database B. That all works fine as long as the user is granted in both databases. I hoped that when I grant the User only to the view in Database A that'll do, but this raise an error that the User in DB B has no rights.

Is there a way to achieve this without granting all users in Database B on the specific table? (perhaps something like executing a view or stored procedure in another security context or something like this?)

Thanx for all comments!

 

[nigelrivett]

See cross database ownership chaining.
Think it was introduced with service pack 3.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[murratore]

Is this possible in SQL Server 7.0??? Yeah, I know...we should upgade but haven't the time ;-)