Re: Rights for view.

Tom Lane пишет:

 >Viacheslav N Tararin <taras@dekasoft.com.ua> writes:
 >
 >
 >>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'?
 >>
 >>
 >
 >You'll need to give more details, because as far as I can tell that
 >works:
 >
---- My test script ----
create user user2 password 'u2';
create schema user2;
create table user2.table1(t1 integer);
create view user2.view1 as select * from user2.table1;
grant select on user2.view1 to user2;
\c - user2;
select * from user2.view1;
select * from user2.table1;

---- My output -----
CREATE USER
CREATE SCHEMA
CREATE TABLE
CREATE VIEW
GRANT
You are now connected as new user user2.
psql:test.sql:7: ERROR:  user2: permission denied
psql:test.sql:8: ERROR:  user2: permission denied


Thanks