[postgis-devel] [postgis-tickets] r15276 - PostGIS upgrade scripts missing GRANT for views

[Regina Obe]

I'm fine with you changing it.

-----Original Message-----
From: strk at kbt.io [mailto:strk at kbt.io] 
Sent: Tuesday, December 20, 2016 3:57 AM
To: Regina Obe <lr at pcorp.us>
Cc: postgis-devel at lists.osgeo.org
Subject: Re: [postgis-tickets] r15276 - PostGIS upgrade scripts missing
GRANT for views

On Mon, Dec 19, 2016 at 04:07:55PM -0800, Regina Obe wrote:
> Author: robe
> Date: 2016-12-19 16:07:54 -0800 (Mon, 19 Dec 2016) New Revision: 15276
> 
> Modified:
>    trunk/utils/postgis_proc_upgrade.pl
> Log:
> PostGIS upgrade scripts missing GRANT for views references #3680 for 
> trunk (PostGIS 2.4)
> 
> Modified: trunk/utils/postgis_proc_upgrade.pl
> ===================================================================
> --- trunk/utils/postgis_proc_upgrade.pl	2016-12-16 18:55:39 UTC (rev
15275)
> +++ trunk/utils/postgis_proc_upgrade.pl	2016-12-20 00:07:54 UTC (rev
15276)
> @@ -378,6 +378,17 @@
>  			last if /\;\s*$/;
>  		}
>  	}
> +	
> +	# Always output grant permissions (see ticket #3680)
> +	if ( /^grant select\s+(\S+)\s*/i )

Why only "select" ?
We might want to grant USAGE on topology one day (currently not done, but
maybe we should...)

--strk;