Dean Rasheed <[EMAIL PROTECTED]> wrote: > Is it only available to superusers?
Presently, yes. > Do we have a general policy on > this? Most logging options are superuser-only, but the recent changes > to LOG debug_print_* output have left them PGC_USERSET. I set it PGC_SUSET because other log_* options have PGC_SUSET. I'm not sure what is the difference between log_* and debug_* ... I think the best policy is to allow general users only to turn "on" those options, but not to turn "off" if the default setting is on. We might need to get default values in postgresq.conf in the context of assignment. Here is a psesudo code. Is it possible? bool log_xxx_assign_hook(newval, source) { if (by SET command && !superuser()) { if (default_value == true && newval == false) elog(ERROR, "You cannot turn off the loggging option"); } return true; /* ok, you can reset it */ } Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers