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
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