Received: from home.macropoint.com (IDENT:root@nisoft-gw.customer.0rbitel.net [195.24.32.214]) by hub.org (8.9.2/8.9.1) with ESMTP id FAA10230 for ; Fri, 5 Feb 1999 05:21:57 -0500 (EST) (envelope-from stancho@macropoint.com) Received: from macropoint.com ([195.24.34.67]) by home.macropoint.com (8.8.7/8.8.7) with ESMTP id MAA06824; Fri, 5 Feb 1999 12:26:05 +0200 Message-ID: <36BAC660.A8BD76FD@macropoint.com> Date: Fri, 05 Feb 1999 12:22:25 +0200 From: Stanimir Stanev Organization: MacroTex www.macrotex.com X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 To: Remigiusz Sokolowski CC: "pgsql-sql@hub.org" Subject: Re: [SQL] Has every postgreSQL database own users? References: Content-Type: multipart/mixed; boundary="------------139204132F3223C4C2713DF8" This is a multi-part message in MIME format. --------------139204132F3223C4C2713DF8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 10x for reply OK, but every database has pg_user table. Why this table is there? Remigiusz Sokolowski wrote: > > hi all > > > > Has every postgreSQL database own users? > > > > for example: > > > > If I have databases with name "db1" and "db2". I want to have user > > "user1" for "db1" and user "user1" (same name, but with other password) > > for "db2". Is this available? > AFAIK this is not possible. Users of postgres are stored in table > pg_shadow and this table is shared between all of databases. I'm not sure > if this is also in case when You create another database system, but > suppose that even in this case user must be unique. > Rem > > -------------------------------------------------------------------*------------ > Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl * * > -----------------------------------------------------------------*****---------- --------------139204132F3223C4C2713DF8 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Stanimir Stanev Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Stanimir Stanev n: Stanev;Stanimir email;internet: stancho@macropoint.com title: software developer x-mozilla-cpt: ;0 x-mozilla-html: TRUE version: 2.1 end: vcard --------------139204132F3223C4C2713DF8--