| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Arnold, Sandra" <ArnoldS(at)osti(dot)gov> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Can the log_statement parameter be set at the user level? |
| Date: | 2010-04-20 21:37:04 |
| Message-ID: | t2sdcc563d11004201437s56e95a70r25ce2733759b25fd@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Tue, Apr 20, 2010 at 1:23 PM, Arnold, Sandra <ArnoldS(at)osti(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Verna Violet | 2010-04-21 00:26:14 | Re: |
| Previous Message | Kevin Grittner | 2010-04-20 20:53:06 | Re: Can the log_statement parameter be set at the user level? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-04-20 21:39:05 | Re: How to terminate a query |
| Previous Message | Scott Marlowe | 2010-04-20 21:35:46 | Re: Rollback Failure |