Re: AW: [HACKERS] Solution to the pg_user passwd problem !?? (c)

Bruce Momjian <maillist@candle.pha.pa.us>

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: scrappy@hub.org (The Hermit Hacker)
Cc: Andreas.Zeugswetter@telecom.at, jwieck@debis.com, pgsql-hackers@hub.org
Date: 1998-02-19T19:46:08Z
Lists: pgsql-hackers
> 
> On Thu, 19 Feb 1998, Bruce Momjian wrote:
> 
> > > 
> > > On Thu, 19 Feb 1998, Bruce Momjian wrote:
> > > 
> > > > > 	Just curious, but why don't the copy command fall under the same
> > > > > grant/revoke restrictions in the first place?  It sounds to me like we are
> > > > > backing off of the problem instead of addressing it...
> > > > 
> > > > grant/revoke works for copy.
> > > 
> > > 	Ah, okay, so when we have it setup so that a view overrides the
> > > 'grant' of a select, then we're fine?
> > 
> > Yep, but can we do that in nine days, and be sure it is tested?
> 
> 	I don't think so...but I'rather have the obviuos "select * from
> pg_user" closed off, and the more obscure "copy pg_user to stdout" still
> there then have both wide open...its a half measure, but its better then
> no measure...

But it is not secure.  Why have passwords then?

-- 
Bruce Momjian
maillist@candle.pha.pa.us