Jukka, Basically, you need read access to the schema.table in question. The spatial views are automatically available if a user has read access to the table. So the minimum access is
GRANT SELECT on SCHEMA.TABLENAME to USERNAME; ALL_SDO_GEOM_METADATA is a view that contains metadata information for all spatial tables on which the user has SELECT permission. It is this view that OGR uses to access Oracle Spatial data. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 10/1/13 4:42 PM, "Jukka Rahkonen" <[email protected]> wrote: >Hi, > >PostGIS manual page has a useful chapter about what rights GDAL user needs > >" You must have permissions on all tables you want to read and >geometry_columns and spatial_ref_sys. >Misleading behavior may follow without an error message if you do not have >permissions to these tables. Permission issues on geometry_columns and/or >spatial_ref_sys tables can be generally confirmed if you can see the >tables >by setting the configuration option PG_LIST_ALL_TABLES to YES. (e.g. >ogrinfo >--config PG_LIST_ALL_TABLES YES PG:xxxxx) " > >Oracle Spatial manual page http://www.gdal.org/ogr/drv_oci.html is missing >this information. I have also a feeling that with Oracle there are more >tables and views and Oracle system stuff involved. Is here anybody who >could >tell what rights GDAL user must have for a) read access b) read and write >access? It would be ideal to have a comprehensive list that could be given >for the ever friendly DB admins > >GRANT [privileges] ON [object_1] TO [user] >GRANT [privileges] ON [object_2] TO [user] >... > > >-Jukka Rahkonen- > >_______________________________________________ >gdal-dev mailing list >[email protected] >http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
