Re: view

[Melvin Davidson <melvin6925@xxxxxxxxx>]

>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 <rameshparnanditech@xxxxxxxxx> 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.