Bug report #1897
SPIT: Schemas not owned by DB-role cannot be accessed
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Low | ||
| Assignee: |  nobody - | ||
| Category: | GUI | ||
| 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 |
Description
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.
Associated revisions
fix #1897
git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@11514 c8812cc2-4d05-0410-92ff-de0c093fc19c
fix #1897
git-svn-id: http://svn.osgeo.org/qgis/trunk@11514 c8812cc2-4d05-0410-92ff-de0c093fc19c
History
#1
Updated by Giovanni Manghi about 15 years ago
Hi,
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 about 15 years ago
- Resolution set to fixed
- Status changed from Open to Closed
fixed in f84685ce (SVN r11515)
#3
Updated by Bernhard Ströbl about 15 years ago
@lutra: tested PostGIS Manager this morning, however my users prefer no-overhead plugins :)
@jef: Thanks for fixing!