НА: How to create users for a login Role?

Поиск
Список
Период
Сортировка
От Evgeniy Losev
Тема НА: How to create users for a login Role?
Дата
Msg-id a47cc0e837e54196a8e8dfcd88b98009@srv-exch-mb02.i-free.local
обсуждение исходный текст
Ответ на How to create users for a login Role?  (KhunSanAung <khunsanaung.gis@gmail.com>)
Ответы Re: How to create users for a login Role?  (KhunSanAung <khunsanaung.gis@gmail.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: KhunSanAung
Дата:
Сообщение: How to create users for a login Role?
Следующее
От: KhunSanAung
Дата:
Сообщение: Re: How to create users for a login Role?