Disallow SET command in a postgresql server

From: Fabio Rueda Carrascosa <avances123(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Disallow SET command in a postgresql server
Date: 2013-04-09 15:28:25
Message-ID: CAA3M-fav3wD_K=jh39VhDLehride_auvo1ty=AjuRs3MwCi7UQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Im planning to publish my postgresql server to a few untrusted clients.

I dont want them to modify any runtime setting, like work_mem or something
risky to my server. In general I assume the pg_catalog schema is public but
I don't want to allow updating pg_settings at all.

Is it possible?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-04-09 15:47:12 Re: Disallow SET command in a postgresql server
Previous Message Sébastien Lorion 2013-04-09 14:34:13 Re: optimizer's cost formulas