Rights for views. - Mailing list pgsql-general

From Viacheslav N Tararin
Subject Rights for views.
Date
Msg-id 3E48FD84.8080404@dekasoft.com.ua
Whole thread Raw
List pgsql-general
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.


pgsql-general by date:

Previous
From: ¾GÁn©M
Date:
Subject: Can I insert Big5 Chinese from Java servlet(Tomcat) to PostgreSQL 7.3
Next
From: Ralph Rotondo
Date:
Subject: accessing currval(), How? ... Trigger? I think...???