pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Users
2+ messages / 2 participants
[nested] [flat]

* Users
@ 2002-06-17 23:46 Andy Pearce <andyj@basesys.co.uk>
  2002-06-18 16:02 ` Re: Users Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 2+ messages in thread

From: Andy Pearce @ 2002-06-17 23:46 UTC (permalink / raw)
  To: pgsql-sql

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.

Does that even make sense?

Thanks

Andy

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Users
  2002-06-17 23:46 Users Andy Pearce <andyj@basesys.co.uk>
@ 2002-06-18 16:02 ` Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruno Wolff III @ 2002-06-18 16:02 UTC (permalink / raw)
  To: Andy Pearce <andyj@basesys.co.uk>; +Cc: pgsql-sql

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-06-18 16:02 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-06-17 23:46 Users Andy Pearce <andyj@basesys.co.uk>
2002-06-18 16:02 ` Bruno Wolff III <bruno@wolff.to>

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