Received: from flash.tibco.com (Splash.TIBCO.COM [192.216.111.239]) by hub.org (8.9.2/8.9.1) with SMTP id FAA13893 for ; Fri, 5 Feb 1999 05:51:57 -0500 (EST) (envelope-from boekhold@tibco.com) Received: by flash.tibco.com (4.1/1.37) id AA03091; Fri, 5 Feb 99 02:45:53 PST Received: from tssgate.tibco.com(160.101.20.20) by flash.tibco.com via smap (V1.3) id sma003086; Fri Feb 5 02:45:50 1999 Received: from ukmail.tibco.com (tekuk01) by tekbspa.tibco.com (4.1/SMI-4.1) id AA10161; Fri, 5 Feb 99 02:45:49 PST Received: from tibco.com by ukmail.tibco.com (SMI-8.6/SMI-4.1) id LAA09823; Fri, 5 Feb 1999 11:00:51 GMT Message-Id: <36BACB43.C72B6D1B@tibco.com> Date: Fri, 05 Feb 1999 11:43:15 +0100 From: Maarten Boekhold X-Mailer: Mozilla 4.5 [en] (WinNT; I) X-Accept-Language: en Mime-Version: 1.0 To: Stanimir Stanev Cc: Remigiusz Sokolowski , "pgsql-sql@hub.org" Subject: Re: [SQL] Has every postgreSQL database own users? References: <36BAC660.A8BD76FD@macropoint.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > > OK, but every database has pg_user table. Why this table is there? > They don't have their own copy. The pg_user (and pg_shadow) table are shared between all databases (think of it as that every database has a symlink to the 'global' pg_user table). Maarten -- Maarten Boekhold, boekhold@tibco.com TIBCO Finance Technology Inc. The Atrium Strawinskylaan 3051 1077 ZX Amsterdam, The Netherlands tel: +31 20 3012158, fax: +31 20 3012358 http://www.tibco.com