[postgis-users] dump/restore permission

[Paragon Corporation]

Which version of PostGIS and PostgreSQL are you running?

I think if you install with CREATE EXTENSION the permissions may not come
back, but those should be public anyway.  I believe in PostGIS 2.0.4 (or was
it 2.0.3), can't remember, we changed to explicitly set these to public read
since they are views and will only list tables user has access to.

Thanks,
Regina
http://www.postgis.us

 

-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Mario Jurcevic
Sent: Monday, September 30, 2013 9:32 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] dump/restore permission

Hi,
after pg_dump/restore each time the permission on "geometry_columns" and
"geography_columns" are lost.
Why of that?

Thanks.

--
Mario
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users