Cross DB ownership chaining

From: Paul (Paul_at_discussions.microsoft.com)
Date: 06/08/05 

Date: Wed, 8 Jun 2005 12:02:02 -0700

Hello,
I am having trouble setting up cross db ownership chaining. Did I omit
anything?

1. Using SQL Server 2000 SP3a.
2. Login as 'sa'.
3. Create new database A1.
4. Create new database A2.
5. Create TableA in database A2.
6. Create view vTableA in database A1 as select * from A2.dbo.TableA
7. Add UserA to database A1.
8. Grant select permission on vTableA to UserA.
9. Enable cross database ownerchip chaining option in database A1 and A2.
10. All objects are owned by dbo and both databases are owned by 'sa'.
11. Log in as UserA and run Select * from vTableA in database A1, get error
"Server user 'UserA' is not a valid user in database 'A2'.".

Unless I'm missing something, I was expecting the last step to work. Any
help greatly appreciated.

Paul

Relevant Pages