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

Marc G. Fournier <scrappy@hub.org>

From: The Hermit Hacker <scrappy@hub.org>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: Zeugswetter Andreas SARZ <Andreas.Zeugswetter@telecom.at>, jwieck@debis.com, pgsql-hackers@hub.org
Date: 1998-02-19T15:59:45Z
Lists: pgsql-hackers
On Thu, 19 Feb 1998, Bruce Momjian wrote:

> > 
> > The command 
> > copy pg_user to stdout;
> > 
> > will also show the cleartext password and I think it is hard to do a rewrite
> > here,
> > since this would also affect the pg_dump ?
> > 
> > * Teardrops keep falling on my head ... *  :-(
> 
> It was brilliant, even if it doesn't fully solve the problem.

	It solves enough of the problem for v6.3's release...I still think
its important to get it so that a 'grant select' can be imposed on a view
that looks at a table that as a 'revoke all' on it...this would fix the
problem cleanly, and completely...

	Then you could do a 'copy all_users to stdout;' vs a 'copy
pg_users to stdout;'