Bug report #1897

SPIT: Schemas not owned by DB-role cannot be accessed

Added by Bernhard Ströbl about 11 years ago. Updated about 11 years ago.

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

Revision 2ad0d87d
Added by Jürgen Fischer about 11 years ago

fix #1897

git-svn-id: http://svn.osgeo.org/qgis/trunk/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

Revision f84685ce
Added by Jürgen Fischer about 11 years ago

fix #1897

git-svn-id: http://svn.osgeo.org/qgis/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

History

#1 Updated by Giovanni Manghi about 11 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 11 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

fixed in f84685ce (SVN r11515)

#3 Updated by Bernhard Ströbl about 11 years ago

@lutra: tested PostGIS Manager this morning, however my users prefer no-overhead plugins :)

@jef: Thanks for fixing!

Also available in: Atom PDF