X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0EC649F9B76 for ; Thu, 4 May 2006 15:21:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 03277-03-2 for ; Thu, 4 May 2006 15:21:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 8CF119F9C10 for ; Thu, 4 May 2006 15:21:21 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id DB70B56431; Thu, 4 May 2006 13:21:20 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 4 May 2006 13:21:20 -0500 Date: Thu, 4 May 2006 13:21:20 -0500 From: "Jim C. Nasby" To: Gary Stainburn Cc: pgsql-admin@postgresql.org Subject: Re: RFC - multi database/application user authentification Message-ID: <20060504182120.GQ97354@pervasive.com> References: <200605041101.17087.gary.stainburn@ringways.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200605041101.17087.gary.stainburn@ringways.co.uk> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060504:gary.stainburn@ringways.co.uk::oPgtiu9KxFOXF+Tc:00000000 0000000000000000000000003UFp X-Hashcash: 1:20:060504:pgsql-admin@postgresql.org::BdDtD7ownFE++lti:00000000000 0000000000000000000000000LQY X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/42 X-Sequence-Number: 21574 I think a better question to be asking yourself is: why are you using seperate databases for all of this? It certainly sounds like all the activities are related, so ISTM it would make a lot more sense to put everything in one database and possibly use schemas to seperate things logically. On Thu, May 04, 2006 at 11:01:16AM +0100, Gary Stainburn wrote: > I have two separate database applications running, one for the initial > Pre-Delivery preparation of new vehicles, and one for the final taxing and > delivery to customers. > > These two systems were developed independently but are used by the same > people. Each of these databases has a user table, used for initial > authentication, and also for logging purposes, i.e. who did what action and > when. Each user table has as it's primary key an int4, but these don't match > between the two systems. > > I am about to develop a new system to encompass the whole order to delivery > process which will mean the creation of a third system with a third database, > user table and authentication process. > > What is the best way to develop an authentication method where one > user-id/password system can be used by three separate databases? > > Is it possible to get postgresql to do this cross-database access or will I > have to handle it in the PHP code? > -- > Gary Stainburn > > This email does not contain private or confidential material as it > may be snooped on by interested government parties for unknown > and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461