Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZlXtb-0001zf-1Y for pgsql-admin@arkaria.postgresql.org; Mon, 12 Oct 2015 07:51:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZlXta-0007V1-EP for pgsql-admin@arkaria.postgresql.org; Mon, 12 Oct 2015 07:51:46 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZlXru-0005aw-UU for pgsql-admin@postgresql.org; Mon, 12 Oct 2015 07:50:03 +0000 Received: from mx1.i-free.com ([89.113.16.106]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZlXrm-00032m-Jz for pgsql-admin@postgresql.org; Mon, 12 Oct 2015 07:50:01 +0000 Received: from srv-exch-mb01.i-free.local (172.27.192.96) by srv-exch-ea01.i-free.local (172.27.254.50) with Microsoft SMTP Server (TLS) id 14.3.224.2; Mon, 12 Oct 2015 10:49:51 +0300 Received: from srv-exch-mb02.i-free.local (172.27.192.97) by srv-exch-mb01.i-free.local (172.27.192.96) with Microsoft SMTP Server (TLS) id 15.0.1044.25; Mon, 12 Oct 2015 10:49:51 +0300 Received: from srv-exch-mb02.i-free.local ([fe80::a9a4:a2f7:b8d8:6e0c]) by srv-exch-mb02.i-free.local ([fe80::a9a4:a2f7:b8d8:6e0c%18]) with mapi id 15.00.1044.021; Mon, 12 Oct 2015 10:49:51 +0300 From: Evgeniy Losev To: KhunSanAung CC: pgsql-admin Subject: Re: How to create users for a login Role? Thread-Topic: [ADMIN] How to create users for a login Role? Thread-Index: AQHRBKdrsRyxBPymJkey8AEjqdxAHZ5ncxF8///US4CAADNaqg== Date: Mon, 12 Oct 2015 07:49:51 +0000 Message-ID: <1444636191243.34374@i-free.com> References: , In-Reply-To: Accept-Language: ru-RU, en-US Content-Language: ru-RU X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [172.27.206.18] Content-Type: multipart/alternative; boundary="_000_144463619124334374ifreecom_" MIME-Version: 1.0 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_144463619124334374ifreecom_ Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Hi. You can create a separate role for database usage and referenig docs at htt= p://www.postgresql.org/docs/9.3/static/sql-grant.html grant particular capa= bilities to it. and then grant the role to your users. Evgeniy Losev Senior System Administrator i-Free Business Solutions ________________________________ =EF=D4: KhunSanAung =EF=D4=D0=D2=C1=D7=CC=C5=CE=CF: 12 =CF=CB=D4=D1=C2=D2=D1 2015 =C7. 10:42 =EB=CF=CD=D5: Evgeniy Losev =EB=CF=D0=C9=D1: pgsql-admin =F4=C5=CD=C1: 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 d= bUser 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 th= e same database (db1Database). Currently if I assign the dbUsers1 as the owner of the database, the 'db1Ow= ner' 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 dat= abase? I'm just a beginner to postgresDB. Many thanks & best regards On Mon, Oct 12, 2015 at 1:48 PM, Evgeniy Losev > wrote: Hi, Please, clarify your question. Do you want to create login role with password and grant it to several user= s? Evgeniy Losev ________________________________ =EF=D4: KhunSanAung =EF=D4=D0=D2=C1=D7=CC=C5=CE=CF: 12.10.2015 7:35 =EB=CF=CD=D5: pgsql-admin =F4=C5=CD=C1: [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=3D# CREATE ROLE dbuser PASSWORD 'secret' SUPERUSER CREATEDB CREATE= ROLE 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 f= rom Window OS. ?Many thanks & best regards? -- Have a nice day! -- Mr. Khun San Aung -- Have a nice day! -- Mr. Khun San Aung --_000_144463619124334374ifreecom_ Content-Type: text/html; charset="koi8-r" Content-Transfer-Encoding: quoted-printable

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 par= ticular capabilities to it.

and then grant the role to your users.


Evgeniy Losev

Senior System Administrator=

i-Free Business Solutions
=EF=D4: KhunSanAung <kh= unsanaung.gis@gmail.com>
=EF=D4=D0=D2=C1=D7=CC=C5=CE=CF: 12 =CF=CB=D4=D1=C2=D2=D1 2015 =C7. 1= 0:42
=EB=CF=CD=D5: Evgeniy Losev
=EB=CF=D0=C9=D1: pgsql-admin
=F4=C5=CD=C1: Re: [ADMIN] How to create users for a login Role?
 
Hi All,

Yes.
I have a database, myD= atabase1 with owner (I think the same as login role) db1Owner.
At the moment, I can l= ogin to the database with above user only. No other dbUser can access to it= .
I have several tables = inside the database.
The database is access= ible 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 dbUser= s1 , dbUsers2, dbUser3,... to be able to access to the same database (db1Da= tabase).
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 multi= ple 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 <= span dir=3D"ltr"> <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 user= s?

Evgeniy Losev
=EF=D4: KhunSa= nAung
=EF=D4=D0=D2=C1=D7=CC=C5=CE=CF: 12.10.= 2015 7:35
=EB=CF=CD=D5: pgsql-= admin
=F4=C5=CD=C1: [ADMIN= ] How to create users for a login Role?



​Dear All,<= /div>

I know how to cre= ate a login role for a postgres database.
I used pgAdmin II= I to create login role and database.
or via psql comma= nd;
postgres=3D# CREATE RO= LE 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?<= /div>
I'd like to allow= multiple users to access to a database.

I used postgres i= nstalled Ubuntu Server and access by pgAdmin III and SSH from Window OS.
​Many thank= s & best regards​

--
Have a nice day!=
--

Mr. Khun San Aung




--
Have a nice day!=
--

Mr. Khun San Aung

=
--_000_144463619124334374ifreecom_--