Log of CREATE USER statement - Mailing list pgsql-hackers

From Ricardo Vaz - TCESP
Subject Log of CREATE USER statement
Date
Msg-id !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA7oYIdZYAKEiHmjZbk4qh78KAAAAQAAAAdCFapRO2EkSQE0RoaoCO4gEAAAAA@tce.sp.gov.br
Whole thread Raw
Responses Re: Log of CREATE USER statement
List pgsql-hackers
<p><font face="Courier New" size="2">Hi,</font><p><font face="Courier New" size="2">I need to log any statement in my
postgresqlserver.</font><br /><font face="Courier New" size="2">However, I would like that the password defined in
CREATEUSER statement was registered in MD5 format, independent of the form as it was specified in that
statement.</font><p><fontface="Courier New" size="2">For example, if the user submits the statement:</font><br /><font
face="CourierNew" size="2">  CREATE USER test ENCRYPTED PASSWORD 'test';</font><br /><font face="Courier New"
size="2">inthe log file it would be registered as:</font><br /><font face="Courier New" size="2">  CREATE USER test
ENCRYPTEDPASSWORD 'md505a671c66aefea124cc08b76ea6d30bb'</font><p><font face="Courier New" size="2">Thus, the password
wouldbe protecting against attacks in log files.</font><p><font face="Courier New" size="2">Is it
possible?</font><p><fontface="Courier New" size="2">Thanks,</font><br /><p><font face="Tahoma" size="2">Ricardo
Vaz</font><br/><font face="Tahoma" size="2">Tribunal de Contas do Estado de São Paulo</font><br /><font face="Tahoma"
size="2">Diretoriade Tecnologia - DTEC</font><br /><font face="Wingdings" size="2">+</font>       <font face="Tahoma"
size="2">RuaVenceslau Brás 183 - 2º andar - Centro</font><br />        <font face="Tahoma" size="2">01016-000 São Paulo
SP</font><br/><font face="Wingdings" size="2">(</font>       <font face="Tahoma" size="2">Fone: (+5511) 3292 3266 ramal
3640</font><br/><font face="Wingdings" size="2">8</font>       <font face="Tahoma" size="2">e-mail:
jrvaz@tce.sp.gov.br</font><br/> 

pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Foreign key trigger timing bug?
Next
From: "Kevin Grittner"
Date:
Subject: Backslashes in string literals