How to grant a user read-only access to a database?

Поиск
Список
Период
Сортировка
От Antonio Goméz Soto
Тема How to grant a user read-only access to a database?
Дата
Msg-id 4B8CF297.4040404@gmail.com
обсуждение исходный текст
Ответы Re: How to grant a user read-only access to a database?
Список pgsql-general
Hi,

I tried this:

names=# grant select on database names to spice;
ERROR:  invalid privilege type SELECT for database

The documentation seems to imply I need to grant SELECT
to each table separately. That's a lot of work, and what if
new tables are created?

Thanks,
Antonio

В списке pgsql-general по дате отправления: