Martin, Just because a user owns a database doesn't mean they have SELECT rights to tables in a database. It's strange I know.
Geometry_columns will only list tables that the user has SELECT rights to. To confirm -- try logged in as this db owner to select from a table that has a geometry column. If you want the db owner to always have full rights to tables in database use: -- handle future tables and ability to regrant as well ALTER DEFAULT PRIVILEGES IN SCHEMA my_schema GRANT ALL ON TABLES TO mydb_admin WITH GRANT OPTION; -- handle existing tabes GRANT ALL ON ALL TABLES IN SCHEMA my_schema TO mydb_admin WITH GRANT OPTION; Repalce my_schema and mydb_admin with schema your tables are in (usually public) and your db owner. Hope that helps, Regina http://www.postgis.us http://postgis.net -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Martin Landa Sent: Saturday, August 02, 2014 4:25 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] geometry_columns and privileges? 2014-08-02 16:50 GMT+02:00 Martin Landa <[email protected]>: > Any idea what could be wrong? Thanks, Martin I guess some privileges magic... ? Martin -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa _______________________________________________ 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
