Re: authentication questions - Mailing list pgsql-novice

From Michael Hanna
Subject Re: authentication questions
Date
Msg-id 8DF20C61-A84A-11D7-BC50-00039308EB2C@hwcn.org
Whole thread Raw
In response to Re: authentication questions  ("Mendola Gaetano" <mendola@bigfoot.com>)
List pgsql-novice
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
>


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Best Practice??
Next
From: Josh Berkus
Date:
Subject: Re: Address Table