[postgis-users] QGIS SPIT import to POSTGIS -

[Richard (Abe) Coughlin]

Luis,

My original issue was that within SPIT it was not allowing the 
non-public schemas to be listed.

It easily finds the shapefile and can create a table in the public 
folder but it wasn't 'seeing' the other schemas.

Remember SPIT is about loading shapefiles to tables in POSTGIS, not 
loading layers.



  Richard (Abe) Coughlin


    _OCEAN INFORMATION SYSTEMS SPECIALIST_
    *PACIOOS - Pacific Islands Ocean Observing System*
    Sea Grant College Program / University of Hawaii
    1-808-956-0822 rac88 at hawaii.edu


On 7/13/2010 10:47 PM, Luís de Sousa wrote:
> Hi again Abe,
>
> So SPIT needs CREATE privileges on the schema to load a postgis layer?
> Am I reading it correctly? It makes no sense...
>
> Luís
>
> On Tue, Jul 13, 2010 at 9:36 PM, rac88<rac88 at hawaii.edu>  wrote:
>    
>> Luis,
>>
>> Thanks for the reply.
>>
>> All the items you mentioned had been addressed.
>>
>> On further investigation I found the solution:
>>
>> QGIS SPIT calls the has_schema_privilege function via the script "select
>> nspname from pg_namespace where has_schema_privilege(nspname, 'CREATE')".
>> Note the second term 'CREATE'.
>>
>> The function has_schema_privilege(schema, privilege) queries whether the
>> current user have the privilege for schema.
>>
>> For schemas, the CREATE privilege allows new objects to be created within
>> the schema.
>>
>> QGIS SPIT did not show the additional schemas as the user had been granted
>> the USAGE privilege only. For the user to create new tables in the schema
>> the user has to have CREATE privileges or ALL privileges or be the owner of
>> the schema (which gives the user ALL privileges).
>>
>> Thanks all for the consideration of my problem.
>>
>> Abe
>>
>>      
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100714/03bf19fa/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: moz-screenshot-2.png
Type: image/png
Size: 25819 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100714/03bf19fa/attachment.png>