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..
Michael
On Thursday, June 26, 2003, at 08:29 PM, Mendola Gaetano wrote:
> ----- Original Message -----
> From: "Michael Hanna" <zen@hwcn.org>
> To: "pgsql-novice" <pgsql-novice@postgresql.org>
> Sent: Thursday, June 26, 2003 10:59 PM
> Subject: [NOVICE] authentication questions
>
>
>> on certain DBs, I want remote access via users who are not unix users
>> on the computer. Do I keep a table of users and passwords?
>
> When you create a DB user nobody oblige you to create also a
> unix user, the table with username and passwd is a system table,
> take a look at pg_shadow ( select * from pg_shadow ).
>
>
> Regards
> Gaetano
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>