Re: Users

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andy Pearce <andyj(at)basesys(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Users
Date: 2002-06-18 16:02:16
Message-ID: 20020618160216.GA28240@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Jun 18, 2002 at 00:46:59 +0100,
Andy Pearce <andyj(at)basesys(dot)co(dot)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.

In response to

  • Users at 2002-06-17 23:46:59 from Andy Pearce

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2002-06-18 22:07:40 text vs varchar
Previous Message Josh Berkus 2002-06-18 15:49:33 Re: Request for builtin function: Double_quote