Re: view

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: Ramesh T <rameshparnanditech(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: view
Date: 2015-09-08 13:44:01
Message-ID: CANu8FiwKPN1jr=6JcmzBuHVTzRgDOK94ZksZWZ00F3sCKQUE_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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.

In response to

  • view at 2015-09-08 12:19:25 from Ramesh T

Responses

  • Re: view at 2015-09-08 14:07:34 from Adrian Klaver

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-09-08 13:46:01 Re: view
Previous Message Giovanni Maruzzelli 2015-09-08 12:59:19 Re: BDR global sequences in two machine failover