Обсуждение: Users

Поиск
Список
Период
Сортировка

Users

От
"Andy Pearce"
Дата:
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

Re: Users

От
Bruno Wolff III
Дата:
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
inpgsql for each user of the system or can I create one user id in pgsql and configure users within the application
usinginfo 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
userwill 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.