Bug report #1897
SPIT: Schemas not owned by DB-role cannot be accessed
|Affected QGIS version:||Regression?:||No|
|Operating System:||All||Easy fix?:||No|
|Pull Request or Patch supplied:||Resolution:||fixed|
|Crashes QGIS or corrupts data:||Copied to github as #:||11957|
When importing shapesfiles with SPIT the user may choose the schema to write the new relation to from a drop-down list. However this list contains only schemas owned by the logged-in database-role.
If the schema is owned by a group role where the logged-in role is a member of it is not listed.
If the logged-in user has create rights on the schema it is not listed either.
To reproduce follow these steps:
1. create a schema as role A
2. grant create rights to this schema to role B
3. start SPIT and log in at the DB as role B
4. choose the shape file and see the combo box in column "schema"
Tested with 1.0.1 on WinXP and 1.1.0 on Linux (SUSE 11.1) so I reckon all platforms and versions are affected.