Re: Cross-Database View Permissions

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 05/29/04

  • Next message: Dan Guzman: "Re: SQL Accounts" 
    Date: Sat, 29 May 2004 09:38:10 -0500

    To add to Jasper's response, both databases need to be owned by the same
    login in order for the dbo-owned object ownership chain to be unbroken.

    Your users still need a security context in database2 but no permissions or
    role memberships need to be granted if objects are only accessed indirectly
    via referencing database1 objects. 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Barnes" <anonymous@discussions.microsoft.com> wrote in message
news:13a2e01c44408$5da79f30$a501280a@phx.gbl...
> 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?
  • Next message: Dan Guzman: "Re: SQL Accounts"