• Enabling DB chaining for the two databases is probably the simple way out.

    However, beware that if one user is db_owner in one database and plain user in the other, this user can exploit the fact that ownership chaining is in force access data in the other database he should not have access to.

    For a longer discussion see the article Giving Permissions through Stored Procedures on my web site.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]