On Tue, Feb 11, 2003 at 18:17:05 +0200,
Viacheslav N Tararin <taras@dekasoft.com.ua> wrote:
> ---- 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
I think you will need to grant select access on the schema or else user2
won't have access to user2.view1 because they don't have access to the schema.
