Re: Password issue revisited

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Shane Ambler <pgsql(at)007Marketing(dot)com>, Michael Schmidt <michaelmschmidt(at)msn(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Password issue revisited
Date: 2007-02-20 15:21:21
Message-ID: 200702201521.l1KFLL823218@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

Magnus Hagander wrote:
> Are we sure we want to do this? (Sorry, didn't notice this thread last
> time)
>
> The default on *all* windows versions since NT 4.0 (which is when the
> directory we use was added) will put this file in a protected directory.
> The only case when it's not protected by default is if you're usnig FAT
> filesystem, in which case there is nothing you can do about it anyway.
> On unix, the file will often be created in outside-readable mode by
> default, depending on how your OS is set up.
>
> So to reach a situation where the file lives in an unprotected
> directory, you must actively open up the directory in question. Which is
> hidden from default view, so you really need to know what you're doing to
> get there.
>
> Not to mention it's a pain to define what permissions are ok and what
> are not. We're talking ACLs and not filemodes - so how do you decide
> which accounts are ok to have access, and which are not?

OK, I added a comment to fe-connect.c explaining why we don't need to
check the permissions of .pgpass, and removed the TODO. Thanks.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Shane Ambler 2007-02-20 17:49:49 Re: Password issue revisited
Previous Message Magnus Hagander 2007-02-20 15:05:07 Re: Password issue revisited

Browse pgsql-general by date

  From Date Subject
Next Message Frank Miles 2007-02-20 16:02:16 Re: open source - content management system - that uses PostGreSQL
Previous Message Guido Neitzer 2007-02-20 15:19:07 Re: Database performance comparison paper.