GRANT SELECT on View

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rui Peres - 14 Oct 2005 16:53 GMT

I have granted SELECT permissions on a view to a user, now when I run the
view it tells me that the user is denied select permissions on a table. The
user does not have any other permissions set on any tables or views other
than the SELECT on this particular view. How can I allow the user to view
this data?

Thank you in advance,
Rui

Reply to this Message

Lori Clark - 14 Oct 2005 17:25 GMT

This sounds like a broken ownership problem. Does the same user (e.g. dbo)
own the view as owns the table? To avoid this problem, both objects will
need to be owned by the same user.

>I have granted SELECT permissions on a view to a user, now when I run the
> view it tells me that the user is denied select permissions on a table.
[quoted text clipped - 5 lines]
> Thank you in advance,
> Rui

Reply to this Message

Rui Peres - 14 Oct 2005 17:37 GMT

Thanks, that did it.

Rui

> This sounds like a broken ownership problem. Does the same user (e.g. dbo)
> own the view as owns the table? To avoid this problem, both objects will
[quoted text clipped - 9 lines]
> > Thank you in advance,
> > Rui

Reply to this Message