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