Re: How to create read-only view on 9.3 - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: How to create read-only view on 9.3
Date
Msg-id 20130813180342.GG2706@tamriel.snowman.net
Whole thread Raw
In response to Re: How to create read-only view on 9.3  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-hackers
* Hannu Krosing (hannu@2ndQuadrant.com) wrote:
> If you earlier used views for granting limited read access to some views
> you definitely did not want view users suddenly gain also write access to
> underlying table.
>
> You also probably did not GRANT only SELECT to your views as this was
> the default anyway,

I'm not really convinced that we should be catering to this argument of
"well, I knew it was gonna end up being read-only anyway, so I just
GRANT'd ALL"- consider that rules can make view writable, even in
existing releases.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: How to create read-only view on 9.3
Next
From: Tom Lane
Date:
Subject: Re: How to create read-only view on 9.3