• For DB_CHAINING to work the two databases must have the same owner.

    For TRUSTWORTHY to work, the databases must either have the same owner, or the owner of the database where the referencing view is must have been granted AUTHENTICATE permission in the target database.

    Both these options opens for the persons in the db_owner role in the respective databases to do things in the other database which maybe they shouldn't. That is, if you have persons who only have db_owner rights in one of the databases.

    Had it been a question of a stored procedure, you could have used certificate signing for more fine-grained permission, but as I recall this does not work for views.

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