[gdal-dev] Minimum user rights needed for Oracle driver

[Jukka Rahkonen]

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-