Home > mailing lists

Re: view - Mailing list pgsql-general

From	Melvin Davidson
Subject	Re: view
Date	September 8, 2015 16:44:45
Msg-id	CANu8FiwKPN1jr=6JcmzBuHVTzRgDOK94ZksZWZ00F3sCKQUE_w@mail.gmail.com Whole thread Raw
In response to	view (Ramesh T <rameshparnanditech@gmail.com>)
Responses	Re: view
List	pgsql-general

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

From: Ramesh T
Date: 08 September 2015, 16:37:22
Subject: view

From: Adrian Klaver
Date: 08 September 2015, 16:46:07
Subject: Re: view