>ERROR: permission denied for relation sub_item So obviously, the user doing the select on the view (ie: YOU) does not have SELECT permission on table sub_item.
On Tue, Sep 8, 2015 at 8:19 AM, Ramesh T <rameshparnandit...@gmail.com> wrote: > HI , > I have view .when i try to select view ,it had return > select * from art; > ERROR: permission denied for relation sub_item > SQL state: 42501 > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.