pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to assign multiple-users to a Postgres database?
2+ messages / 2 participants
[nested] [flat]
* How to assign multiple-users to a Postgres database?
@ 2015-07-06 10:26 KhunSanAung <khunsanaung.gis@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: KhunSanAung @ 2015-07-06 10:26 UTC (permalink / raw)
To: pgsql-admin
Hi All,
I'm using Postgres database, and using the postGIS extensions for storing
spatial datasets.
I can create a user and a database.
Currently I can assign one user as owner per one database and can login
with pgAdminIII for administrating task.
I'd like to allow more than one user to edit the data.
Is it possible to create multiple users for a database?
How can I do it?
Thank you very much for any help.
--
Have a nice day!
--
*Mr. Khun San Aung*
* <http://geoportal.icimod.org/>*
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to assign multiple-users to a Postgres database?
@ 2015-07-06 11:27 Yves Jacolin <yves.jacolin@camptocamp.com>
parent: KhunSanAung <khunsanaung.gis@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Yves Jacolin @ 2015-07-06 11:27 UTC (permalink / raw)
To: pgsql-admin; KhunSanAung.GIS@gmail.com
On Monday, July 06, 2015 16:56:59 KhunSanAung wrote:
> Hi All,
>
> I'm using Postgres database, and using the postGIS extensions for storing
> spatial datasets.
>
> I can create a user and a database.
> Currently I can assign one user as owner per one database and can login
> with pgAdminIII for administrating task.
>
> I'd like to allow more than one user to edit the data.
> Is it possible to create multiple users for a database?
> How can I do it?
>
> Thank you very much for any help.
Hello,
A short answer: you should create a ROLE for each user and give some grant
access to the database (and probably to Scheme and Table):
The GRANT synopsis is:
GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE database_name [, ...]
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
So, one example could be:
GRANT CONNECT ON DATABASE mydb TO yjacolin;
Regards,
Yves
--
Responsable Formation et Support
Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex
Tel (France) : +33 4 58 48 20 43 (new !)
Tel (Suisse) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21
Fax : 04 79 70 15 81
Mail : yves.jacolin@camptocamp.com
http://www.camptocamp.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-07-06 11:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-07-06 10:26 How to assign multiple-users to a Postgres database? KhunSanAung <khunsanaung.gis@gmail.com>
2015-07-06 11:27 ` Yves Jacolin <yves.jacolin@camptocamp.com>
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