[postgis-devel] [PostGIS] #1795: spatial_ref_sys, geometry_columns, raster views should be publicly readable

[PostGIS]

#1795: spatial_ref_sys, geometry_columns, raster views should be publicly readable
-----------------------------------+----------------------------------------
 Reporter:  robe                   |       Owner:  strk         
     Type:  defect                 |      Status:  new          
 Priority:  medium                 |   Milestone:  PostGIS 2.0.1
Component:  build/upgrade/install  |     Version:  2.0.x        
 Keywords:                         |  
-----------------------------------+----------------------------------------
 This is probably something we should do for 1.5 as well but at least for
 extensions, all works out of the box except if you are using an account
 other than the one you installed extensions with, you have to explicitly
 grant permissions to public for spatial_ref_sys and I'm guessing
 geometry_columns as well.

 I don't see why we can't always have an explicit public on these as part
 of the install process.  geometry_columns,raster_columns etc now that they
 are all views are safe to make public since I believe we now only list
 tables that are visible to the user querying the view, so there is no risk
 of them seeing tables listed they have no access to.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1795>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.