pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRFC - multi database/application user authentification
3+ messages / 2 participants
[nested] [flat]
* RFC - multi database/application user authentification
@ 2006-05-04 10:01 Gary Stainburn <gary.stainburn@ringways.co.uk>
2006-05-04 18:21 ` Re: RFC - multi database/application user authentification Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 3+ messages in thread
From: Gary Stainburn @ 2006-05-04 10:01 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: RFC - multi database/application user authentification
2006-05-04 10:01 RFC - multi database/application user authentification Gary Stainburn <gary.stainburn@ringways.co.uk>
@ 2006-05-04 18:21 ` Jim C. Nasby <jnasby@pervasive.com>
2006-05-09 09:50 ` Re: RFC - multi database/application user authentification Gary Stainburn <gary.stainburn@ringways.co.uk>
0 siblings, 1 reply; 3+ messages in thread
From: Jim C. Nasby @ 2006-05-04 18:21 UTC (permalink / raw)
To: Gary Stainburn <gary.stainburn@ringways.co.uk>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: RFC - multi database/application user authentification
2006-05-04 10:01 RFC - multi database/application user authentification Gary Stainburn <gary.stainburn@ringways.co.uk>
2006-05-04 18:21 ` Re: RFC - multi database/application user authentification Jim C. Nasby <jnasby@pervasive.com>
@ 2006-05-09 09:50 ` Gary Stainburn <gary.stainburn@ringways.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Gary Stainburn @ 2006-05-09 09:50 UTC (permalink / raw)
To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: pgsql-admin
Hi Jim
I have considered your comments and they make good sense. As the 2 existing
systems integrate with the new one, they will work more and more closely, so
I will work on doing as you suggest.
Gary
On Thursday 04 May 2006 19:21, Jim C. Nasby wrote:
> 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
--
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-05-09 09:50 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-04 10:01 RFC - multi database/application user authentification Gary Stainburn <gary.stainburn@ringways.co.uk>
2006-05-04 18:21 ` Jim C. Nasby <jnasby@pervasive.com>
2006-05-09 09:50 ` Gary Stainburn <gary.stainburn@ringways.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox