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