Postresql/postgis/qgis : assign privileges only for access/reading tables ?

Поиск
Список
Период
Сортировка
От celati Laurent
Тема Postresql/postgis/qgis : assign privileges only for access/reading tables ?
Дата
Msg-id CAHByMH3i7qFOk65_O1+hNAP8CowC+DEWUeTFA6fSZ4DhFmwnmw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postresql/postgis/qgis : assign privileges only for access/reading tables ?  (Ben Madin <ben@ausvet.com.au>)
Список 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 по дате отправления:

Предыдущее
От: 张进涛
Дата:
Сообщение: ask for help:I want to compile a dynamic library file, such as libpsqlodbc w.so
Следующее
От: Dennis Schwan
Дата:
Сообщение: RSYNC YUM Mirror for pg14 not available yet