grant permissions to set variable?

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: grant permissions to set variable?
Date: 2007-03-14 15:18:45
Message-ID: B5A97688-C414-4D6B-93DD-45792CFD8652@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to do some debugging on an app, and I'd like to set on a per-
connection basis "set log_min_duration_statement = 10;" Obviously
since I'm not super user I get permission denied.

Is there some GRANT I can grant to the user in question to allow
this? I don't really want to do it globally or for all connections
by that user, both of which are easy to do

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2007-03-14 15:35:45 Re: Trigger Question
Previous Message Jaime Silvela 2007-03-14 15:16:18 DST failing on 8.1.3