[Qgis-developer] Problem editing geometries with no-owner user in Oracle spatial 11g via QGIS

[eglatorre]

Médéric Ribreux-2 wrote
> you need to grant update,delete and insert for the other user on the 
> tables .
> ...

Done


Médéric Ribreux-2 wrote
> You probably want to add read/write rights to index tables too (MDRT_*).

This was not enough... at least in our case.

The solution came from granting rights specifically to the geometry column
("GEOM") with:
GRANT UPDATE ("GEOM") ON "MYSCHEMA"."MYTABLE" TO "OTHERSCHEMA_USER";

It seems that other software like MapInfo and MicroStation would not check
for rights on the geometry column since editing geometries in the Oracle
database worked withouth this right being set.

Thanks a lot Médéric!!





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-editing-geometries-with-no-owner-user-in-Oracle-spatial-11g-via-QGIS-tp5272138p5274602.html
Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.