From: Bruno Wolff III <bruno@wolff.to>
To: Andy Pearce <andyj@basesys.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Users
Date: Tue, 18 Jun 2002 11:02:16 -0500
Message-ID: <20020618160216.GA28240@wolff.to> (raw)
In-Reply-To: <000801c21659$59ac26f0$020010ac@dellboy>
References: <000801c21659$59ac26f0$020010ac@dellboy>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, andyj@basesys.co.uk
Subject: Re: Users
In-Reply-To: <20020618160216.GA28240@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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