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 <[email protected]> > 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 <[email protected]> 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 >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > > > -- > Luis Eduardo Carrasco, Ph.D. > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
