[postgis-users] Postresql/postgis/qgis : assign privileges only for access/reading tables ?
laurent.celati at gmail.com
Thu Oct 14 02:16:28 PDT 2021
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
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
Where can the error come from? Have I forgotten something?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users