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.
git-svn-id: http://svn.osgeo.org/qgis/trunk/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c
git-svn-id: http://svn.osgeo.org/qgis/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c
#1 Updated by Giovanni Manghi almost 14 years ago
have you tested the postgis manager plugin?
I guess that SPIT is not being developed any more and that postgis manager is the new reference plugin for interacting with postgis.
#2 Updated by Jürgen Fischer almost 14 years ago
- Resolution set to fixed
- Status changed from Open to Closed
fixed in f84685ce (SVN r11515)
#3 Updated by Bernhard Ströbl almost 14 years ago
@lutra: tested PostGIS Manager this morning, however my users prefer no-overhead plugins :)
@jef: Thanks for fixing!