[postgis-users] Postresql/postgis/qgis : assign privileges only for access/reading tables ?
didierp.ulb at disroot.org
Thu Oct 14 05:49:05 PDT 2021
Maybe : " GRANT USAGE ON schema ... TO ... " ?
> Le 14 oct. 2021 à 11:16, celati Laurent <laurent.celati at 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 at lists.osgeo.org
More information about the postgis-users