Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 56F96476395 for ; 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 ; 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 ; Tue, 18 Jun 2002 00:47:29 +0100 Envelope-To: Message-ID: <000801c21659$59ac26f0$020010ac@dellboy> From: "Andy Pearce" To: 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

Hi,

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

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?

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.

Does that even make sense?

Thanks

Andy

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