We have a view in db1 which is based in a table in db2. User is a member of a NT group which has db_reader role in both databases. When user runs select queries pointing to view in db1, he gets following error message:
Msg 916, Level 14, State 1, Line 1
The server principal "user" is not able to access the database "db2" under the current security context.
I googled alot but could not find useful solution. I would appreciate any help.