Cross-Database View Permissions

From: Barnes (anonymous_at_discussions.microsoft.com)
Date: 05/27/04


Date: Thu, 27 May 2004 09:33:39 -0700

I have a view in database1 that uses views in database2.
My DBA says I must give users DATA READER permissions to
the tables referenced by the database2 views. I am trying
to keep customers OUT of the tables, only allowing access
thru views.

Do I really have to give DATA READER to the tables in
database2 to get my cross-database view references to work?