How to create users for a login Role?

From: KhunSanAung <khunsanaung(dot)gis(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: How to create users for a login Role?
Date: 2015-10-12 04:34:21
Message-ID: CAAQr1jZZW+Ku=GXOgYfGm_REsWVn4=u0H=V1Nk9uzZKgkGFrwQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

​Dear All,

I know how to create a login role for a postgres database.
I used pgAdmin III to create login role and database.
or via psql command;
postgres=# CREATE ROLE dbuser PASSWORD 'secret' SUPERUSER CREATEDB
CREATEROLE INHERIT LOGIN;

I'd like to know how to create users/members for each login role.
How can I do it?
I'd like to allow multiple users to access to a database.

I used postgres installed Ubuntu Server and access by pgAdmin III and SSH
from Window OS.

​Many thanks & best regards​

--
Have a nice day!
--

*Mr. Khun San Aung*
* <http://geoportal.icimod.org/>*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Evgeniy Losev 2015-10-12 07:18:26 НА: How to create users for a login Role?
Previous Message Khaled McGonnell 2015-10-11 21:11:06 Can't install