pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan the log_statement parameter be set at the user level?
3+ messages / 3 participants
[nested] [flat]
* Can the log_statement parameter be set at the user level?
@ 2010-04-20 19:23 Arnold, Sandra <ArnoldS@osti.gov>
0 siblings, 2 replies; 3+ messages in thread
From: Arnold, Sandra @ 2010-04-20 19:23 UTC (permalink / raw)
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>; pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can the log_statement parameter be set at the user level?
@ 2010-04-20 20:53 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Arnold, Sandra <ArnoldS@osti.gov>
1 sibling, 0 replies; 3+ messages in thread
From: Kevin Grittner @ 2010-04-20 20:53 UTC (permalink / raw)
To: Sandra Arnold <ArnoldS@osti.gov>; pgsql-admin; pgsql-general@postgresql.org <pgsql-general@postgresql.org>
"Arnold, Sandra" <ArnoldS@osti.gov> wrote:
> Can the log_statement configuration parameter be set at the user
level?
ALTER USER userid SET log_statement = 'none';
-Kevin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can the log_statement parameter be set at the user level?
@ 2010-04-20 21:37 Scott Marlowe <scott.marlowe@gmail.com>
parent: Arnold, Sandra <ArnoldS@osti.gov>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Marlowe @ 2010-04-20 21:37 UTC (permalink / raw)
To: Arnold, Sandra <ArnoldS@osti.gov>; +Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>; 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-04-20 21:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-04-20 19:23 Can the log_statement parameter be set at the user level? Arnold, Sandra <ArnoldS@osti.gov>
2010-04-20 20:53 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-04-20 21:37 ` Scott Marlowe <scott.marlowe@gmail.com>
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