Cross-Database View Permissions
From: Barnes (anonymous_at_discussions.microsoft.com)
Date: 05/27/04
- Next message: Stefan Berglund: "Re: ISV Using SQL Authentication - a login concern"
- Previous message: Don Mc: "Do I have a Spy software"
- Next in thread: Jasper Smith: "Re: Cross-Database View Permissions"
- Reply: Jasper Smith: "Re: Cross-Database View Permissions"
- Reply: Dan Guzman: "Re: Cross-Database View Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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?
- Next message: Stefan Berglund: "Re: ISV Using SQL Authentication - a login concern"
- Previous message: Don Mc: "Do I have a Spy software"
- Next in thread: Jasper Smith: "Re: Cross-Database View Permissions"
- Reply: Jasper Smith: "Re: Cross-Database View Permissions"
- Reply: Dan Guzman: "Re: Cross-Database View Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]