How to create a read only user account to access to all pg database?

Поиск
Список
Период
Сортировка
От KhunSanAung
Тема How to create a read only user account to access to all pg database?
Дата
Msg-id CAAQr1jZihBKxfXk8q=Y60RVqCixdJ2yrp_HLNuja0NKDM_PGLQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to create a read only user account to access to all pg database?  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: How to create a read only user account to access to all pg database?  (Ville Rantamaula <ville.rantamaula@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Hi All,

I have several pg database with their own login user account.
For backup purpose, I'd like to create an additional read only user account that can access all the pg database.
How can I do it?
Via PSQL command or via pgAdmin III client would be okay.

Your help is high appreciated.

Many thanks & best regards

--
Have a nice day!
--

Mr. Khun San Aung

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

Предыдущее
От: "Williams, Alex"
Дата:
Сообщение: Re: Question on Hot Standby in PostgreSQL
Следующее
От: KhunSanAung
Дата:
Сообщение: How to store the PSQL command result into an array or Python dictionary?