[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Postresql/postgis/qgis : assign privileges only for access/reading tables ?
From: Didier Peeters <didierp.ulb () disroot ! org>
Date: 2021-10-14 12:49:05
Message-ID: 2ECF31F8-2396-4973-9858-E289310D1C0E () disroot ! org
[Download RAW message or body]
Hello Laurent,
Maybe : " GRANT USAGE ON schema ... TO ... " ?
Didier
> Le 14 oct. 2021 à 11:16, celati Laurent <laurent.celati@gmail.com> a écrit :
>
> Good morning,
>
> I work on Postgresql/postgis and Qgis.
> I had created a superuser account for me.
> In qgis, I can see the postgis schemas and tables and browse the tables without problem.
>
> This time, i created another simple user account just to be able with qgis
> to access and load the table in qgis.
> In pgadmin I created a new role with privileges "can login" only.
> Then, i tape :
>
> GRANT SELECT ON ALL TABLES IN SCHEMA TO USER
>
> The request is well recognized and carried out.
> But in qgis GIS, I only see the schema structure, I don't see the list of spatial tables.
> Where can the error come from? Have I forgotten something?
>
> Thank you.
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic