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 490229FADD1 for ; Thu, 4 May 2006 07:22:54 -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 05130-09 for ; Thu, 4 May 2006 07:22:43 -0300 (ADT) X-Greylist: delayed 00:20:40.786399 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 17D769F9B76 for ; Thu, 4 May 2006 07:22:43 -0300 (ADT) Received: from mail.ringways.co.uk (host-80-193-83-141.static.telewest.net [80.193.83.141]) by svr4.postgresql.org (Postfix) with ESMTP id 0F2D15B66BD for ; Thu, 4 May 2006 10:02:00 +0000 (GMT) Received: from eddie.ringways.co.uk ([10.1.1.115]) by mail.ringways.co.uk with esmtp (Exim 4.61) (envelope-from ) id 1Fbae5-0005a1-9R for pgsql-admin@postgresql.org; Thu, 04 May 2006 11:01:17 +0100 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@postgresql.org Subject: RFC - multi database/application user authentification Date: Thu, 4 May 2006 11:01:16 +0100 User-Agent: KMail/1.9.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200605041101.17087.gary.stainburn@ringways.co.uk> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/35 X-Sequence-Number: 21567 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