Postresql/postgis/qgis : assign privileges only for access/reading tables ? - Mailing list pgsql-general

From celati Laurent
Subject Postresql/postgis/qgis : assign privileges only for access/reading tables ?
Date
Msg-id CAHByMH3i7qFOk65_O1+hNAP8CowC+DEWUeTFA6fSZ4DhFmwnmw@mail.gmail.com
Whole thread Raw
Responses Re: Postresql/postgis/qgis : assign privileges only for access/reading tables ?
List pgsql-general
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 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. 

pgsql-general by date:

Previous
From: 张进涛
Date:
Subject: ask for help:I want to compile a dynamic library file, such as libpsqlodbc w.so
Next
From: Dennis Schwan
Date:
Subject: RSYNC YUM Mirror for pg14 not available yet