moving object function disabled with Oracle provider

[qgib]

Author Name: sylvain pierre (sylvain pierre)
Original Redmine Issue: 10374
Affected QGIS version: 2.2.0
Redmine category:data_provider/oracle

---

QGIS 2.2 with connection to Oracle spatial.

When I try to edit point layer, moving object function is disabled.
Adding function is enabled an run well.

With postgis layer, function is enabled.

Regards

Sylvain

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• fixed_version_id was changed from Version 2.2 to Future Release - Lower Priority

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• category_id was changed from Data Provider to Data Provider/Oracle

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• assigned_to_id was configured as Jürgen Fischer

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Does "Editing capabilities of this layer" in the meta data page of the layer's properties include "Change Geometries"? It should, if you have UPDATE privilege on the geometry column of the table in Oracle.

[BTW your email address bounces]

[qgib]

Author Name: sylvain pierre (sylvain pierre)

---

With french translation, properties are:
"Ajouter des entités, Supprimer des entités, Changer des valeurs attributaires, Créer un index spatial, Accès rapide aux entités via l'ID" =>
Add entity,delete entity, change attribute values, create spatial index, fast access via ID but no "Change geomatries".
I've looked for privilege fot the table I'm working on with my account and here is DELETE, INSERT, SELECT and UPDATE...

[qgib]

Author Name: sylvain pierre (sylvain pierre)

---

Another clue:
I think issue relies on QgsVectorDataProvider::ChangeGeometries property (I'm not a C++ expert;-))
This property value is set by scanning all_col_privs oracle view which in my case is totaly empty.
So I think it is a DBA problem.
My DBA has not implemented column level security.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

sylvain pierre wrote:

This property value is set by scanning all_col_privs oracle view which in my case is totaly empty.

Correct.

So I think it is a DBA problem.
My DBA has not implemented column level security.

I didn't know that you can disable it - and I can't find any pointer how or how you can verify whether it's enabled or not.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• regression was configured as 0
• easy_fix was configured as 0

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• assigned_to_id removed Jürgen Fischer

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Appears not to be a qgis issue

---

• resolution was changed from to invalid
• description was changed from QGIS 2.2 with connection to Oracle spatial.

When I try to edit point layer, moving object function is disabled.
Adding function is enabled an run well.

With postgis layer, function is enabled.

Regards

Sylvain to QGIS 2.2 with connection to Oracle spatial.

When I try to edit point layer, moving object function is disabled.
Adding function is enabled an run well.

With postgis layer, function is enabled.

Regards

Sylvain

• status_id was changed from Open to Closed