RE: Stored procedure permissions cross database

From: Mike Epprecht (SQL MVP) (
Date: 08/30/05

Date: Tue, 30 Aug 2005 08:09:10 -0700

Support for SQL Server 2005 Beta/CTP in the SQL Server 2005 Communities:

Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program:
"" wrote:
> We're on the SQLServer 2005 CTP.
> We granted execute permissions to a user for stored procedures in DB1,
> but some of the procedures reference tables in DB2, and these won't
> work.
> All of the objects have dbo. , but the databases were created by
> different logins.
> I've seen some posts about using sp_configure 'cross db ownership
> chaining' but I also see some warnings in help about security and
> wonder if it's the best answer.
> We can certainly recreate DB1 using the same login that created DB2, if
> that's the easiest way to make this work.
> Jim