From: Scott Marlowe <scott.marlowe@gmail.com>
To: Arnold, Sandra <ArnoldS@osti.gov>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Can the log_statement parameter be set at the user level?
Date: Tue, 20 Apr 2010 15:37:04 -0600
Message-ID: <t2sdcc563d11004201437s56e95a70r25ce2733759b25fd@mail.gmail.com> (raw)
In-Reply-To: <54E5385D47A89542BC678F5426799F390498CB3139@OSTIEX01.osti.gov>
References: <54E5385D47A89542BC678F5426799F390498CB3139@OSTIEX01.osti.gov>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, ArnoldS@osti.gov, pgsql-general@postgresql.org
Subject: Re: Can the log_statement parameter be set at the user level?
In-Reply-To: <t2sdcc563d11004201437s56e95a70r25ce2733759b25fd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox