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

[celati Laurent]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211014/699998c5/attachment.html>