Re: authentication questions

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: "Michael Hanna" <zen(at)hwcn(dot)org>
Cc: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: authentication questions
Date: 2003-06-27 09:48:34
Message-ID: 002301c33c91$46aa5b80$152aa8c0@GMENDOLA2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Michael Hanna" <zen(at)hwcn(dot)org> wrote:
> ok, to avoid having too many users in pg_shadow, could I make a user
> called 'webapp' in pg_shadow who had access to one particular DB only,
> and this DB could contain a table of all the users who use that web
> application? seems more efficient that way..

In that way you have less controll on who is using the DB,
for example you can not use current_user in order to know
who is doing the query and you can not use the privileges on
tables, stored procedure, views.....
and last but not least why you are aware about "do not fill the
pg_shadow"?

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rory Campbell-Lange 2003-06-27 12:20:39 SELECT too complex?
Previous Message christoph.dellavalle 2003-06-27 08:13:59 missing postmaster.conf