Re: How to create read-only view on 9.3

Hi,

(2013/08/14 5:24), Josh Berkus wrote:> On 08/13/2013 11:18 AM, Tom Lane wrote:>> Hannu Krosing <hannu@2ndQuadrant.com>
writes:>>>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.>>>> Unless you'd explicitly granted those users insert/update/delete 
privilege>> on the view, they wouldn't suddenly be able to do something new in 9.3,>> because no such privileges are
grantedby default.  If you had granted>> such privileges, you don't have much of a leg to stand on for 
 
complaining>> that now they can do it.>> Ah, ok.  I hadn't gotten to the testing phase yet.>> I think we should have a
scriptavailable for revoking all write privs> on all views and link it from somewhere (the release notes?), but I>
don'tsee any need to change anything in the release.>
 
Yes, I was not thinking about changing current 9.3 behavior.
So I think it's enough to know the impact and how to avoid that
on the release notes.

thanks a lot!

regards,
-------------------
NTT Software Corporation
Tomonari Katsumata