[postgis-tickets] [PostGIS] #4575: GRANT select on topology metadata tables to public

PostGIS trac at osgeo.org
Wed Nov 13 07:53:38 PST 2019


#4575: GRANT select on topology metadata tables to public
-----------------------+---------------------------
  Reporter:  strk      |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.1.0
 Component:  topology  |    Version:  master
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by robe):

 Oh wait I remember why we did it on just those.  Not sure the reason is
 that important though.

 For geography_columns and geometry_columns -- they are both views, so what
 you can see in them is already dictated by visibility of the table to the
 user.

 That said if a user can't see X table, that X table doesn't show in
 geography/geometry columns views either.

 Topology is a real table, so there is some concern there.

 spatial_ref_sys wasn't of much concern because it's largely static table
 that anybody can see by looking at postgis source code anyway.

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


More information about the postgis-tickets mailing list