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

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
www.shreeyansh.com

On Wed, Nov 25, 2015 at 9:05 AM, KhunSanAung <khunsanaung(dot)gis(at)gmail(dot)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*
> * <http://geoportal.icimod.org/>*
>