Select from view1 will be passed to table1(kinda like a symbolic link),
so you need
give user2 access to table1 too.
Viacheslav N Tararin wrote:
> Hi.
> Hext problem:
> I have table table1 with owner user1;
> I have view view1 based only on table1 owner user1 too.
> I have user2 which not own anything.
> user1 grant rights to select on view1 to user2.
>
> Why user2 when try select from view1 get 'table1: permission denied'?
>
> Thanks.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster