Alrighty then, Bob, how? 😛
My view in database B is running a query along the lines of,
JOIN DatabaseB.dbo.Table2 ON Table1.Column = Table2.Column
I don't want to give the user access to tables 1 and 2. What I want is to give the user access to the view in database B. So, I go in and give the user SELECT permission on the view. But, when the user tries to run queries accessing the view, EG SELECT * FROM [View], a PERMISSION DENIED error is thrown, specifically, "The server principal [UserName] is not able to access the database [Database A] under the current security context."