On Tue, Jun 18, 2002 at 00:46:59 +0100, Andy Pearce <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
