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

[Sandro Santilli]

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;