<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Luis,<br>
<br>
My original issue was that within SPIT it was not allowing the
non-public schemas to be listed.<br>
<br>
It easily finds the shapefile and can create a table in the public
folder but it wasn't 'seeing' the other schemas.<br>
<br>
Remember SPIT is about loading shapefiles to tables in POSTGIS, not
loading layers.<br>
<br>
<img src="cid:part1.09000207.03010306@hawaii.edu" alt=""><br>
<br>
<div class="moz-signature">
<h1 style="font-family: arial; font-size: 100%; color: black;"> Richard
(Abe) Coughlin</h1>
<h2 style="font-family: arial; font-size: 100%;"><u>OCEAN INFORMATION
SYSTEMS SPECIALIST</u>
<br>
<b>PACIOOS - Pacific Islands Ocean Observing System</b>
<br>
Sea Grant College Program / University of Hawaii
<br>
1-808-956-0822 <a class="moz-txt-link-abbreviated" href="mailto:rac88@hawaii.edu">rac88@hawaii.edu</a></h2>
</div>
<br>
On 7/13/2010 10:47 PM, Luís de Sousa wrote:
<blockquote
cite="mid:AANLkTilq4DUeOlqHllXV_WgaBlOjLotHNGM7IfnNFHEv@mail.gmail.com"
type="cite">
<pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:rac88@hawaii.edu"><rac88@hawaii.edu></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
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
</pre>
</blockquote>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>