Log of CREATE USER statement
От | Ricardo Vaz - TCESP |
---|---|
Тема | Log of CREATE USER statement |
Дата | |
Msg-id | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA7oYIdZYAKEiHmjZbk4qh78KAAAAQAAAAdCFapRO2EkSQE0RoaoCO4gEAAAAA@tce.sp.gov.br обсуждение исходный текст |
Ответы |
Re: Log of CREATE USER statement
|
Список | 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 по дате отправления: