[postgis-users] permission denied for relation geometry_columns on postgis 2.x

[Pietro Rossin]

No, I didn't
Gisadmin user isn't the owner of the postgis db and I don't like it to be
so (superuser).
It must only  create tables and edit them
And there are users that can only query tables..
I know there are roles, groups and users in postgres but I didn't
understand how to use them efficiently...
By the way, thanks!
pietro


2013/5/21 Luis Carrasco <leca00 at gmail.com>

> If I understand your problem correctly, have you tried changing ownership
> to the geometry_columns and geometry_columns (and raster_columns) views  to
> gisadmin? That's if gisadmin owns the database you are trying to connect to.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> On Tue, May 21, 2013 at 8:13 AM, Pietro Rossin <pierigis at gmail.com> wrote:
>
>> Hello all
>> how can I solve this problem?
>> With postgres user no problem (of course), but I made a gisadmin user
>> which
>> I thought I gave enough grants..
>> geometry_columns with postgis 2.x is not a table but a view that, if I'm
>> not
>> wrong, is updated by some trigger/function
>>
>> How can I make it usable/selectable by users?
>>
>> Thanks
>> Pietro
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://postgis.17.x6.nabble.com/permission-denied-for-relation-geometry-columns-on-postgis-2-x-tp5003338.html
>> Sent from the PostGIS - User mailing list archive at Nabble.com.
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
>
> --
> Luis Eduardo Carrasco, Ph.D.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130521/9d7b1726/attachment.html>