In an MS SQL 2005 instance there are two databases.
A specific user has execute rights on the dbo schema for both of these databases.
In database A I have a stored procedure which contains a select statement on a table in database B.
Are the dbo schema execute permissions sufficient for this call, or will the user have to have select access on the table in database B?
We use stored procedures for all database access and would prefer the user only have execute rights.