Can the log_statement parameter be set at the user level?

From: "Arnold, Sandra" <ArnoldS(at)osti(dot)gov>
To: "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: Can the log_statement parameter be set at the user level?
Date: 2010-04-20 19:23:18
Message-ID: 54E5385D47A89542BC678F5426799F390498CB3139@OSTIEX01.osti.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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.

Thanks,

Sandra Arnold
Sr. Database Administrator
NCI
DOE/OSTI
Oak Ridge, TN

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-04-20 20:53:06 Re: Can the log_statement parameter be set at the user level?
Previous Message Tom Lane 2010-04-20 16:43:57 Re: pg_restore -j

Browse pgsql-general by date

  From Date Subject
Next Message Peter Hunsberger 2010-04-20 19:32:42 Re: Ltree - how to sort nodes on parent node
Previous Message Ben Chobot 2010-04-20 19:16:31 Re: [GENERAL] Specific database vars, again...