Log of CREATE USER statement

Поиск
Список
Период
Сортировка
От Ricardo Vaz - TCESP
Тема Log of CREATE USER statement
Дата
Msg-id !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA7oYIdZYAKEiHmjZbk4qh78KAAAAQAAAAGdvCc5MNVUC1a6DClyuv3QEAAAAA@tce.sp.gov.br
обсуждение исходный текст
Список pgsql-general
Hi,

I need to log any statement in my postgresql server.
However, I would like that the password defined in CREATE USER statement
was registered in MD5 format, independent of the form where it was
specified in the statement.

For example, if the user submits the statement:
  CREATE USER test ENCRYPTED PASSWORD 'test';
in the log file it would be registered as:
  CREATE USER test ENCRYPTED PASSWORD
'md505a671c66aefea124cc08b76ea6d30bb'

Thus, the password would be protecting against attacks in log files.

Is it possible?

Thanks,

Ricardo Vaz
Tribunal de Contas do Estado de São Paulo
Diretoria de Tecnologia - DTEC
*    Rua Venceslau Brás 183 - 2º andar - Centro
    01016-000 São Paulo SP
*    Fone: (+5511) 3292 3266 ramal 3640
*    e-mail: jrvaz@tce.sp.gov.br




В списке pgsql-general по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: fts, compond words?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Memory Leakage Problem