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;
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--
В списке pgsql-admin по дате отправления: