Postgres Pro
Downloads
Home   >   mailing lists

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

From KhunSanAung
Subject How to create users for a login Role?
Date
Msg-id CAAQr1jZZW+Ku=GXOgYfGm_REsWVn4=u0H=V1Nk9uzZKgkGFrwQ@mail.gmail.com
Whole thread Raw
Responses НА: How to create users for a login Role?  (Evgeniy Losev <e.losev@i-free.com>)
Re: How to create users for a login Role?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view

​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: Guillaume Lelarge
Date:
Subject: Re: Long-running and non-finishing VACUUM ANALYZE on large table
Next
From: Evgeniy Losev
Date:
Subject: НА: How to create users for a login Role?