Postgres Pro
Downloads
Home   >   mailing lists

НА: How to create users for a login Role? - Mailing list pgsql-admin

From Evgeniy Losev
Subject НА: How to create users for a login Role?
Date
Msg-id a47cc0e837e54196a8e8dfcd88b98009@srv-exch-mb02.i-free.local
Whole thread Raw
In response to How to create users for a login Role?  (KhunSanAung <khunsanaung.gis@gmail.com>)
Responses Re: How to create users for a login Role?  (KhunSanAung <khunsanaung.gis@gmail.com>)
List pgsql-admin
Tree view
Hi,
Please, clarify your question.
Do you want to create login role with password and grant it to several users?

Evgeniy Losev
От: KhunSanAung
Отправлено: 12.10.2015 7:35
Кому: pgsql-admin
Тема: [ADMIN] How to create users for a login Role?


​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

pgsql-admin by date:

Previous
From: KhunSanAung
Date:
Subject: How to create users for a login Role?
Next
From: KhunSanAung
Date:
Subject: Re: How to create users for a login Role?