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

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Sandro Santilli-3
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;
_______________________________________________
postgis-devel mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Regina Obe-2
I'm fine with you changing it.

-----Original Message-----
From: [hidden email] [mailto:[hidden email]]
Sent: Tuesday, December 20, 2016 3:57 AM
To: Regina Obe <[hidden email]>
Cc: [hidden email]
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;

_______________________________________________
postgis-devel mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-devel
Loading...