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

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

A simple way is Create a user with superuser privileges and read only permission.

-Login psql as postgres or other superuser.
-Create the new superuser role and set it to read only :

CREATE USER backupadmn WITH PASSWORD 'pwd' SUPERUSER ;
ALTER USER backupadmn set default_transaction_read_only = on;


Regards,
Sagar Jadhav
Database Administrator



On Wed, Nov 25, 2015 at 9:05 AM, KhunSanAung <khunsanaung.gis@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Abbas
Дата:
Сообщение: Re: function nvl(numeric, integer) does not exist
Следующее
От: Ville Rantamaula
Дата:
Сообщение: Re: How to create a read only user account to access to all pg database?