Re: Can the log_statement parameter be set at the user level?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Can the log_statement parameter be set at the user level?
Дата
Msg-id t2sdcc563d11004201437s56e95a70r25ce2733759b25fd@mail.gmail.com
обсуждение исходный текст
Ответ на Can the log_statement parameter be set at the user level?  ("Arnold, Sandra" <ArnoldS@osti.gov>)
Список pgsql-admin
On Tue, Apr 20, 2010 at 1:23 PM, Arnold, Sandra <ArnoldS@osti.gov> wrote:
> Can the log_statement configuration parameter be set at the user level?  For
> auditing purposes I need to capture certain statements being executed by
> specific accounts.  However, there are some accounts that it would be nice
> not to be logging this information nor is it required.  If log_statement can
> be set at the user level, then I can set it to not log 'mod' for the
> accounts that I do not want this detail.

Yep. As Kevin mentioned, it can be set by role / user.  Also by
database and by cluster. User overrides db, db overrides cluster.

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Can the log_statement parameter be set at the user level?
Следующее
От: Verna Violet
Дата:
Сообщение: Re: