Stored procedure permissions cross database

jhcorey_at_yahoo.com
Date: 08/30/05 

Date: 30 Aug 2005 06:32:10 -0700

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