Can the log_statement parameter be set at the user level?

am 20.04.2010 21:23:18 von ArnoldS

--_000_54E5385D47A89542BC678F5426799F390498CB3139OSTIEX01ost ig_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Can the log_statement configuration parameter be set at the user level? Fo=
r 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 ca=
n be set at the user level, then I can set it to not log 'mod' for the acco=
unts that I do not want this detail.

Thanks,

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

--_000_54E5385D47A89542BC678F5426799F390498CB3139OSTIEX01ost ig_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Can the=20
log_statement configuration parameter be set at the user level? For=20
auditing purposes I need to capture certain statements being executed by=20
specific accounts. However, there are some accounts that it would be =
nice=20
not to be logging this information nor is it required. If log_stateme=
nt=20
can be set at the user level, then I can set it to not log 'mod' for the=20
accounts that I do not want this detail.

face=3DArial>

face=3DArial>Thanks,

Sandra Arnold

Sr. Datab=
ase=20
Administrator

face=3DArial>NCI

face=3DArial>DOE/OSTI

Oak Ridge=
,=20
TN

--_000_54E5385D47A89542BC678F5426799F390498CB3139OSTIEX01ost ig_--

Re: Can the log_statement parameter be set at the user

am 20.04.2010 22:53:06 von Kevin Grittner

"Arnold, Sandra" wrote:

> Can the log_statement configuration parameter be set at the user
level?

ALTER USER userid SET log_statement = 'none';

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Can the log_statement parameter be set at the user level?

am 20.04.2010 23:37:04 von Scott Marlowe

On Tue, Apr 20, 2010 at 1:23 PM, Arnold, Sandra wrote:
> Can the log_statement configuration parameter be set at the user level?=
=A0 For
> auditing purposes I need to capture certain statements being executed by
> specific accounts.=A0 However, there are some accounts that it would be n=
ice
> not to be logging this information nor is it required.=A0 If log_statemen=
t 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.

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin