|
Posted by Dan Guzman on 10/01/67 11:32
> The user has to have select permissions on the table for the view to work,
> right?
No. Permissions on indirectly referenced objects are not checked as long as
the ownership chain is unbroken. The ownership chain is unbroken as long as
the objects involved are owned by the same user. This allows you to limit
user access to views and stored procedures while preventing direct access to
the underlying objects. Users only need permissions on those objects they
access directly. See the Books Online for more information on ownership
chains.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Morten Mikkelsen" <mbmnewsreader_@_mikkelsens.net> wrote in message
news:43805880$0$47068$edfadb0f@dread15.news.tele.dk...
> Dan Guzman wrote:
>> Does the user have permissions on the table? In that case, the table
>> will be visible in the list.
>
> The user has to have select permissions on the table for the view to work,
> right?
>
>
> /M
Navigation:
[Reply to this message]
|