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;'