Re: Can the log_statement parameter be set at the user level? - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Can the log_statement parameter be set at the user level?
Date
Msg-id t2sdcc563d11004201437s56e95a70r25ce2733759b25fd@mail.gmail.com
Whole thread Raw
In response to Can the log_statement parameter be set at the user level?  ("Arnold, Sandra" <ArnoldS@osti.gov>)
List 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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Can the log_statement parameter be set at the user level?
Next
From: Verna Violet
Date:
Subject: Re: