[QGIS-trac] [Quantum GIS] #1897: SPIT: Schemas not owned by DB-role cannot be accessed

[Quantum GIS]

#1897: SPIT: Schemas not owned by DB-role cannot be accessed
------------------------------------------------+---------------------------
   Reporter:  best                              |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.0.3
  Component:  GUI                               |            Version:  1.1.0        
   Keywords:  SPIT schema rights                |   Platform_version:               
   Platform:  All                               |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 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.[[BR]]
 If the logged-in user has create rights on the schema it is not listed
 either.

 To reproduce follow these steps:[[BR]]
 1. create a schema as role A[[BR]]
 2. grant create rights to this schema to role B[[BR]]
 3. start SPIT and log in at the DB as role B[[BR]]
 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.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1897>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats