RE: Stored procedure permissions cross database

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
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:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005

-- 
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"jhcorey@yahoo.com" 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
> 
> 


Relevant Pages