Hi,
Please, clarify your question.
Do you want to create login role with password and grant it to several users?
Evgeniy Losev
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
