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

[Smith, Michael ERDC-RDE-CRREL-NH]

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" <jukka.rahkonen at mmmtike.fi> 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
>gdal-dev at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/gdal-dev