From: Yves Jacolin <yves.jacolin@camptocamp.com>
To: pgsql-admin@postgresql.org, KhunSanAung.GIS@gmail.com
Subject: Re: How to assign multiple-users to a Postgres database?
Date: Mon, 06 Jul 2015 13:27:24 +0200
Message-ID: <9642342.zDFveqarPE@tatras>
Organization: Camptocamp
User-Agent: KMail/4.13.3 (Linux/3.13.0-55-generic; KDE/4.13.3; x86_64; ; )
In-Reply-To: 
 <CAAQr1javZp6_RE_u6pot==9WRReM9QJu2zmiF0ZwaYVwitfnow@mail.gmail.com>
References: 
 <CAAQr1javZp6_RE_u6pot==9WRReM9QJu2zmiF0ZwaYVwitfnow@mail.gmail.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="us-ascii"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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