MS SQL Server - Permissions on Views

Author

Permissions on Views

MGeles

2006-03-27, 8:23 pm

I've created two new views along with a new login that I'd like to only have
select permission on these new views. I've created the views and granted
select permission to the new user to these views. The first view, which
invloves only one table, works fine. The second is giving me problems and I
don't quite understand why.

The 2nd view joins 2 tables, which are owned by dbo, with 2 views, which are
owned by another user. I've verified that the view references the correct
owners and I've granted select permission to the user to this view, but I
keep getting select permission denied on the 4 objects being referenced in
the view, unless I grant select permissions to the objects that I want to
restrict.

What am I missing here?

Any help is appreciated
Thanks
Mike
--
MG

David Browne

2006-03-27, 8:23 pm

"MGeles" <michael.geles@thomson.com> wrote in message
news:79C5BB72-2C87-4D86-87FC- 71B4F388AF2F@microso
ft.com...
> I've created two new views along with a new login that I'd like to only
> have
> select permission on these new views. I've created the views and granted
> select permission to the new user to these views. The first view, which
> invloves only one table, works fine. The second is giving me problems and
> I
> don't quite understand why.
>
> The 2nd view joins 2 tables, which are owned by dbo, with 2 views, which
> are
> owned by another user. I've verified that the view references the correct
> owners and I've granted select permission to the user to this view, but I
> keep getting select permission denied on the 4 objects being referenced in
> the view, unless I grant select permissions to the objects that I want to
> restrict.
>
> What am I missing here?
>

The ownership chain is broken.

See

Using Ownership Chains
http://msdn.microsoft.com/library/d...curity_4iyb.asp

David

Sponsored Links