| 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.
| 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 |