From: Adrian Klaver <adrian.klaver@gmail.com>
To: pgsql-general@postgresql.org
Cc: salah jubeh <s_jubeh@yahoo.com>
Sent: Tue, May 24, 2011 4:13:38 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
>
> SELECT * FROM A;
Who are you executing the above as?
>
> 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.
As was mentioned earlier the issue is in the relationship between A and B. As a
user you may have permission to both A and B and can access either. The A view
though may have permissions that do not allow it to access B. As was pointed
out the ability of A to select from B is dependent on As permissions, not the
the user initiating the select.
>
> Regards
--
Adrian Klaver
adrian.klaver@gmail.com