Views permision -- please help and suggestion - Mailing list pgsql-general

From salah jubeh
Subject Views permision -- please help and suggestion
Date
Msg-id 35794.97520.qm@web161518.mail.bf1.yahoo.com
Whole thread Raw
Responses Re: Views permision -- please help and suggestion  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
I have two views A and B such that A depend on B. Both of them has the same permissions. 

when I excute

SELECT * FROM  A;

ERROR:  permission denied for relation B

********** Error **********

ERROR: permission denied for relation B
SQL state: 42501


However, I can do

SELECT * FROM  B;

How can I trace this problem, It really confuses me.

Regards

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: postgres crash - illegal instruction
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 9.01 error database help