Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id E55CC476905 for ; 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 ; 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 To: Andy Pearce Cc: pgsql-sql@postgresql.org Subject: Re: Users Message-ID: <20020618160216.GA28240@wolff.to> Mail-Followup-To: Andy Pearce , 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 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.