From brett.maton@itaccounting.co.uk Tue Oct  14 16:40:54 2003
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id C79D5D1B58E
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Tue, 14 Oct 2003 16:40:54 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 38229-03
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Tue, 14 Oct 2003 13:40:23 -0300 (ADT)
Received: from itaccounting.co.uk (host217-40-80-121.in-addr.btopenworld.com
	[217.40.80.121])
	by svr1.postgresql.org (Postfix) with ESMTP id 20DCCD1B56E
	for <pgsql-interfaces@postgresql.org>;
	Tue, 14 Oct 2003 13:38:29 -0300 (ADT)
Received: from [192.168.1.22] (HELO ITAXP003)
	by itaccounting.co.uk (CommuniGate Pro SMTP 4.0.6)
	with SMTP id 272011 for pgsql-interfaces@postgresql.org;
	Tue, 14 Oct 2003 17:40:18 +0100
Message-ID: <001e01c39271$9d0c3ad0$1601a8c0@ITAXP003>
From: "Brett Maton" <brett.maton@itaccounting.co.uk>
To: <pgsql-interfaces@postgresql.org>
Subject: Intercept database  Connection request
Date: Tue, 14 Oct 2003 17:38:35 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_001B_01C39279.FEC446C0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_30_40
X-Spam-Level: 
X-Archive-Number: 200310/30
X-Sequence-Number: 4519

This is a multi-part message in MIME format.

------=_NextPart_000_001B_01C39279.FEC446C0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Is it possible to intercept database connection requests via a trigger or s=
omething ?

I have a front end application which uses a fixed user name password to con=
nect to the database and then does it's own authentication / access rights =
management.

We currently have in the region of 5,000 users and I really don't want to h=
ave to create "actual" database user accounts for each one....
------=_NextPart_000_001B_01C39279.FEC446C0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Is it possible to intercept database conne=
ction=20
requests via a trigger or something ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have a front end application which uses =
a fixed=20
user name password to connect to the database and then does it's own=20
authentication / access rights management.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>We currently have in the region of 5,000 u=
sers and=20
I really don't want to have to create "actual" database user accounts for e=
ach=20
one....</FONT></DIV></BODY></HTML>

------=_NextPart_000_001B_01C39279.FEC446C0--





From brett.maton@itaccounting.co.uk Wed Oct  15 08:22:57 2003
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id B5136D1B508
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Oct 2003 08:22:57 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 91610-09
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Oct 2003 05:22:28 -0300 (ADT)
Received: from itaccounting.co.uk (host217-40-80-121.in-addr.btopenworld.com
	[217.40.80.121])
	by svr1.postgresql.org (Postfix) with ESMTP id 0C27ED1B52F
	for <pgsql-interfaces@postgresql.org>;
	Wed, 15 Oct 2003 05:22:10 -0300 (ADT)
Received: from [192.168.1.22] (HELO ITAXP003)
	by itaccounting.co.uk (CommuniGate Pro SMTP 4.0.6)
	with SMTP id 272102 for pgsql-interfaces@postgresql.org;
	Wed, 15 Oct 2003 09:24:05 +0100
Message-ID: <003401c392f5$71f5c1c0$1601a8c0@ITAXP003>
From: "Brett Maton" <brett.maton@itaccounting.co.uk>
To: <pgsql-interfaces@postgresql.org>
Subject: Intercept database  Connection request
Date: Wed, 15 Oct 2003 09:22:17 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0031_01C392FD.D3A4A5F0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_30_40
X-Spam-Level: 
X-Archive-Number: 200310/33
X-Sequence-Number: 4522

This is a multi-part message in MIME format.

------=_NextPart_000_0031_01C392FD.D3A4A5F0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Is it possible to intercept database connection requests via a trigger or s=
omething ?

I have a front end application which uses a fixed user name password to con=
nect to the database and then does it's own authentication / access rights =
management.

We currently have in the region of 5,000 users and I really don't want to h=
ave to create "actual" database user accounts for each one....
------=_NextPart_000_0031_01C392FD.D3A4A5F0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Is it possible to intercept database conne=
ction=20
requests via a trigger or something ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have a front end application which uses =
a fixed=20
user name password to connect to the database and then does it's own=20
authentication / access rights management.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>We currently have in the region of 5,000 u=
sers and=20
I really don't want to have to create "actual" database user accounts for e=
ach=20
one....</FONT></DIV></BODY></HTML>

------=_NextPart_000_0031_01C392FD.D3A4A5F0--