From: Evgeniy Losev <e.losev@i-free.com>
To: KhunSanAung <khunsanaung.gis@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: How to create users for a login Role?
Date: Mon, 12 Oct 2015 07:49:51 +0000
Message-ID: <1444636191243.34374@i-free.com> (raw)
In-Reply-To: <CAAQr1jbLzzzjCVP2CwoBqrRDs-MSBn=Pph9hAuQm3dUvA2bCug@mail.gmail.com>
References: <CAAQr1jZZW+Ku=GXOgYfGm_REsWVn4=u0H=V1Nk9uzZKgkGFrwQ@mail.gmail.com>
<a47cc0e837e54196a8e8dfcd88b98009@srv-exch-mb02.i-free.local>
<CAAQr1jbLzzzjCVP2CwoBqrRDs-MSBn=Pph9hAuQm3dUvA2bCug@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi.
You can create a separate role for database usage and referenig docs at http://www.postgresql.org/docs/9.3/static/sql-grant.html grant particular capabilities to it.
and then grant the role to your users.
Evgeniy Losev
Senior System Administrator
i-Free Business Solutions
________________________________
От: KhunSanAung <khunsanaung.gis@gmail.com>
Отправлено: 12 октября 2015 г. 10:42
Кому: Evgeniy Losev
Копия: pgsql-admin
Тема: Re: [ADMIN] How to create users for a login Role?
Hi All,
Yes.
I have a database, myDatabase1 with owner (I think the same as login role) db1Owner.
At the moment, I can login to the database with above user only. No other dbUser can access to it.
I have several tables inside the database.
The database is accessible only with the above login. It is not accessible to other role/user.
What I like to have is create several users for a database.
e.g.
I like to allow dbUsers1 , dbUsers2, dbUser3,... to be able to access to the same database (db1Database).
Currently if I assign the dbUsers1 as the owner of the database, the 'db1Owner' cannot not access to the 'myDatabase1' database.
How can I allow multi users to allow to access and edit the database?
How can I create multiple database users to allow to access to the same database?
I'm just a beginner to postgresDB.
Many thanks & best regards
On Mon, Oct 12, 2015 at 1:48 PM, Evgeniy Losev <e.losev@i-free.com<mailto:e.losev@i-free.com>> wrote:
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
<http://geoportal.icimod.org/;
--
Have a nice day!
--
Mr. Khun San Aung
<http://geoportal.icimod.org/;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: e.losev@i-free.com, khunsanaung.gis@gmail.com
Subject: Re: How to create users for a login Role?
In-Reply-To: <1444636191243.34374@i-free.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox