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
