Re: Help with tracking!

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Help with tracking!
Дата
Msg-id j2udcc563d11004200503z75d163f9xf20152dfaffafef3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Help with tracking!  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: Help with tracking!  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Список pgsql-general
2010/4/18 Craig Ringer <craig@postnewspapers.com.au>:
> Đỗ Ngọc Trí Cường wrote:
>> Dear all,
>>
>> I've a problem but I search all the help file and can't find the solution.
>>
>> I want to track all action of a specify role on all or one schema in
>> database.
>>
>> Can you help me?
>
> You can use statement-level logging, though there are no facilities in
> statement-level logging to restrict what is logged to only one role's
> activity.

Wouldn't this work:

alter user smarlowe set log_statement = 'all';

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Culturally aware initcap
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Help with tracking!