Bruce Momjian [EMAIL PROTECTED] writes:
/* Limit non-superuser changes */
if (record-context == PGC_USERLIMIT
source PGC_S_UNPRIVILEGED
newval conf-session_val
^^^
I had in mind
On Wed, Aug 13, 2003 at 06:05:46PM -0400, Bruce Momjian wrote:
I tried adding this line:
record-session_source PGC_S_UNPRIVILEGED
and it does allow you to set the variable to false if you have set it to
true in your session, but it also allows you to set it to false if it is
set
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
/* Limit non-superuser changes */
if (record-context == PGC_USERLIMIT
source PGC_S_UNPRIVILEGED
newval conf-session_val
^^^
I had in mind
Bruce Momjian [EMAIL PROTECTED] writes:
Yes, I have been thinking of that. The big question is whether a
non-super user can control the reset value?
He could (via PGOPTIONS) ... but since he can only increase it, there is
nothing to fear.
regards, tom lane
[ Moved to hackers.]
Tom Lane wrote:
Bertrand Petit [EMAIL PROTECTED] writes:
Non superusers can set log_statement to true but can't set it
back to false even if log_statement was false at the begining of a
connection.
Yeah. I think that the restrictions for USERLIMIT variables