Postgres Pro
Downloads
Home   >   mailing lists

grant permissions to set variable? - Mailing list pgsql-general

From Vivek Khera
Subject grant permissions to set variable?
Date
Msg-id B5A97688-C414-4D6B-93DD-45792CFD8652@khera.org
Whole thread Raw
Responses Re: grant permissions to set variable?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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
Attachment

pgsql-general by date:

Previous
From: "MG"
Date:
Subject: max_connections (postgresql.conf)
Next
From: Jaime Silvela
Date:
Subject: DST failing on 8.1.3