[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:                         |  
-----------------------------------+----------------------------------------

Comment(by strk):

 At that point also public usage on topology (for calling functions) and
 select on topology.topology and topology.layer ? For creating topologies
 you'll also need schema creation rights, but even without you should be
 able to read existing ones.

 I'm not sure permissions should be tweaked by the default install script.
 It would be up to the DBA to decide what to do with which roles.

 Maybe we could provide utility SQL scripts to do it in one way (the way we
 think makes more sense).
 It should be checked if existence of "public" can be relied upon.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1795#comment:2>
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.