Good morning,
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 in qgis
to access and load the table in qgis.
In pgadmin I created a new role with privileges "can login" only.
When 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 tables.
Where can the error come from? Have I forgotten something?
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 in qgis
to access and load the table in qgis.
In pgadmin I created a new role with privileges "can login" only.
When 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 tables.
Where can the error come from? Have I forgotten something?
Thank you.