On 05/24/2011 10:04 AM, salah jubeh wrote:
Hello Adrian,
I have changed the permission of one table where view B depend on and my
problem is over. Still; the whole issue is confusing me.
See here for explanation:
http://www.postgresql.org/docs/9.0/interactive/sql-createview.html
"Access to tab
PM
Subject: Re: [GENERAL] Views permision -- please help and suggestion
On Tuesday, May 24, 2011 6:50:38 am salah jubeh wrote:
> I have two views A and B such that A depend on B. Both of them has the same
> permissions.
What are the permissions?
>
>
> when I excute
>
> S
On Tuesday, May 24, 2011 6:50:38 am salah jubeh wrote:
> I have two views A and B such that A depend on B. Both of them has the same
> permissions.
What are the permissions?
>
>
> when I excute
>
> SELECT * FROM A;
Who are you executing the above as?
>
> ERROR: permission denied for relat
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;
H
