From andyj@basesys.co.uk Mon Jun  17 23:48:01 2002
Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 56F96476395
	for <pgsql-sql@postgresql.org>; Mon, 17 Jun 2002 19:48:01 -0400 (EDT)
Received: from s1.uklinux.net (mail.uklinux.net [80.84.72.21])
	by postgresql.org (Postfix) with ESMTP id 0AC0D47630F
	for <pgsql-sql@postgresql.org>; Mon, 17 Jun 2002 19:47:28 -0400 (EDT)
Received: from dellboy (interra.demon.co.uk [212.228.237.31]) (authenticated)
	by s1.uklinux.net (8.11.6/8.11.6) with ESMTP id g5HNlSQ06469
	for <pgsql-sql@postgresql.org>; Tue, 18 Jun 2002 00:47:29 +0100
Envelope-To: <pgsql-sql@postgresql.org>
Message-ID: <000801c21659$59ac26f0$020010ac@dellboy>
From: "Andy Pearce" <andyj@basesys.co.uk>
To: <pgsql-sql@postgresql.org>
Subject: Users
Date: Tue, 18 Jun 2002 00:46:59 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01C21661.A75F3AB0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Archive-Number: 200206/223
X-Sequence-Number: 8188

This is a multi-part message in MIME format.

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

Hi,

This may be the wrong forum, but I'm sure someone can help!

I'm writing a VB application that uses PostgreSQL as the database backend. =
Is it common practice to create a user id in pgsql for each user of the sys=
tem or can I create one user id in pgsql and configure users within the app=
lication using info from a table in the database?=20

The reason I'm asking is that either way I need to create the table in the =
database to decide what privileges each user will have, that will affect th=
e application not the database.

Does that even make sense?

Thanks

Andy

------=_NextPart_000_0005_01C21661.A75F3AB0
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.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>This may be the wrong forum, but I'm sure =
someone=20
can help!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'm writing a VB application that uses Pos=
tgreSQL=20
as the database backend. Is it common practice to create a user id in pgsql=
 for=20
each user of the system or can I create one user id in pgsql and configure =
users=20
within the application using info from a table in the database? </FONT></DI=
V>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The reason I'm asking is that either way I=
 need to=20
create the table in the database to decide what privileges each user will h=
ave,=20
that will affect the application not the database.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Does that even make sense?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Andy</FONT></DIV></BODY></HTML>

------=_NextPart_000_0005_01C21661.A75F3AB0--




From bruno@wolff.to Tue Jun  18 17:16:00 2002
Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id E55CC476905
	for <pgsql-sql@postgresql.org>; Tue, 18 Jun 2002 13:16:00 -0400 (EDT)
Received: from wolff.to (wolff.to [66.92.219.49])
	by postgresql.org (Postfix) with SMTP id 5CBBC477703
	for <pgsql-sql@postgresql.org>; Tue, 18 Jun 2002 11:57:30 -0400 (EDT)
Received: (qmail 28287 invoked by uid 500); 18 Jun 2002 16:02:16 -0000
Date: Tue, 18 Jun 2002 11:02:16 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Andy Pearce <andyj@basesys.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Users
Message-ID: <20020618160216.GA28240@wolff.to>
Mail-Followup-To: Andy Pearce <andyj@basesys.co.uk>, pgsql-sql@postgresql.org
References: <000801c21659$59ac26f0$020010ac@dellboy>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <000801c21659$59ac26f0$020010ac@dellboy>
User-Agent: Mutt/1.3.25i
X-Archive-Number: 200206/230
X-Sequence-Number: 8195

On Tue, Jun 18, 2002 at 00:46:59 +0100,
  Andy Pearce <andyj@basesys.co.uk> wrote:
> Hi,
> 
> This may be the wrong forum, but I'm sure someone can help!
> 
> I'm writing a VB application that uses PostgreSQL as the database backend. Is it common practice to create a user id in pgsql for each user of the system or can I create one user id in pgsql and configure users within the application using info from a table in the database? 
> 
> The reason I'm asking is that either way I need to create the table in the database to decide what privileges each user will have, that will affect the application not the database.

Depend on what your access rules are you may be able to implement the
rules using views. Then they would be enforced by the database.