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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Foreign key trigger timing bug?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Backslashes in string literals