[postgis-users] geometry_columns and privileges?

[Paragon Corporation]

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: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] 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 <landa.martin at gmail.com>:
> 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
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users