Re: [HACKERS] Here it is - view permissions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Here it is - view permissions
Date
Msg-id 199802211649.LAA26669@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Here it is - view permissions  (jwieck@debis.com (Jan Wieck))
Responses Re: [HACKERS] Here it is - view permissions
List pgsql-hackers
>
>     No,  there  isn't more on that. It's just to be more backward
>     compatible. Users out there  might  have  already  views  and
>     since  it  wasn't neccessary to set explicit permissions on a
>     view up to now (views  inherited  the  permissions  from  all
>     tables  they select), it's unlikely that anyone out there set
>     them up.
>
>     I think it's better to implement something that's  a  key  to
>     open  the  door  instead of opening it by default and telling
>     where's the key to lock it back.

This code is big enough without adding system table columns to allow
backward compatability.  Just tell them as part of the upgrade, they
need to set GRANT/REVOKE on views.  Put it in the /migration files too.

--
Bruce Momjian
maillist@candle.pha.pa.us

pgsql-hackers by date:

Previous
From: "Thomas A. Szybist"
Date:
Subject: Re: [PORTS] Sparc/Linux oddity...
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Here it is - view permissions