Postgres Pro
Downloads
Home   >   mailing lists

Re: Security Issues: Allowing Clients to Execute SQL in the Backend. - Mailing list pgsql-general

From Geoff Montee
Subject Re: Security Issues: Allowing Clients to Execute SQL in the Backend.
Date
Msg-id CAA7biFNB_xWU3fvLxzgGNY53MSVMrpVQdtpsZ_Q7aJ78Yj_Q_A@mail.gmail.com
Whole thread Raw
In response to Re: Security Issues: Allowing Clients to Execute SQL in the Backend.  (Hello World <worldanizer@gmail.com>)
List pgsql-general
Tree view
They don't apply server-wide. They apply to that user's session:


Geoff


On Wed, Apr 30, 2014 at 6:19 AM, Hello World <worldanizer@gmail.com> wrote:

SET statement_timeout=0;
SET work_mem=1024GB;

I just realized about the SET command.

Isn't it weird that any user can set parameters such as this that will apply server wide? to all future sessions?

I noticed that some of the parameters can only be set by superusers, and some require re-start, but still. Anybody can re-configure the server..... ??

pgsql-general by date:

Previous
From: David Noel
Date:
Subject: Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)
Next
From: "Tomas Vondra"
Date:
Subject: Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)