[postgis-users] QGIS SPIT import to POSTGIS -

[Luís de Sousa]

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
>