Opened 5 years ago

Closed 5 years ago

#4576 closed defect (invalid)

GRANT select on raster_columns and other raster metadata tables to public

Reported by: strk Owned by: dustymugs
Priority: medium Milestone: PostGIS 3.1.0
Component: raster Version: master
Keywords: Cc:

Description

We do this already for geography_columns, geometry_columns and spatial_ref_sys so I don't see why we shouldn't do for raster metadata tables as well

Change History (4)

comment:1 by strk, 5 years ago

Related ticket (topology): #4575

comment:2 by robe, 5 years ago

Weird I thought we had done this already.

comment:3 by robe, 5 years ago

raster_columns is fine to make public readable because now it's a view like geometry_columns/geography_columns

so I think it has the same settings as geometry/geography in that tables a user doesn't have rights don't get listed in the view.

comment:4 by strk, 5 years ago

Resolution: invalid
Status: newclosed

Oops, we did already: raster/rt_pg/rtpostgis.sql.in:9233:GRANT SELECT ON TABLE raster_columns TO public; raster/rt_pg/rtpostgis.sql.in:9234:GRANT SELECT ON TABLE raster_overviews TO public;

Note: See TracTickets for help on using tickets.