[postgis-users] Postresql/postgis/qgis : assign privileges only for access/reading tables ?

[Didier Peeters]

Hello Laurent,

Maybe : " GRANT USAGE ON schema ... TO ... " ?

Didier

> 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
> https://lists.osgeo.org/mailman/listinfo/postgis-users