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

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

For write access, one needs INSERT and/or UPDATE on an existing table. For
a new table, a user needs CREATE TABLE and CREATE SEQUENCE access to a
Schema and some tablespace allocation for the schema, ALTER USER USERNAME
QUOTA <SIZE> on TABLESPACE Y,   or GRANT UNLIMITED TABLESPACE to USERNAME.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 10/1/13 4:58 PM, "Smith, Michael ERDC-RDE-CRREL-NH"
<Michael.Smith at erdc.dren.mil> wrote:

>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
>
>_______________________________________________
>gdal-dev mailing list
>gdal-dev at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/gdal-dev