Postgres Pro
Downloads
Home   >   mailing lists

Re: How to create a read only user account to access to all pg database? - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: How to create a read only user account to access to all pg database?
Date
Msg-id CAGDYbUN0iv97o0p=hZqeVmqh33YVmrGDhv3XcHs6bpy_VjuqJw@mail.gmail.com
Whole thread Raw
In response to How to create a read only user account to access to all pg database?  (KhunSanAung <khunsanaung.gis@gmail.com>)
Responses Re: How to create a read only user account to access to all pg database?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Abbas
Date:
Subject: Re: function nvl(numeric, integer) does not exist
Next
From: Ville Rantamaula
Date:
Subject: Re: How to create a read only user account to access to all pg database?