pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Fuhr <mike@fuhr.org>
To: Thiago Maluf <malufrj@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Disable access shell command in psql
Date: Mon, 23 Jul 2007 08:16:35 -0600
Message-ID: <20070723141634.GA7388@winnie.fuhr.org> (raw)
In-Reply-To: <c8bf7e920707230659p2feec45ao9a699a3e9792fc91@mail.gmail.com>
References: <c8bf7e920707230659p2feec45ao9a699a3e9792fc91@mail.gmail.com>

On Mon, Jul 23, 2007 at 10:59:17AM -0300, Thiago Maluf wrote:
> I have one database server with postgresql 8.1 and I discovered  yesterday
> one  security problem.
> When  I access my server with  thought psql I have the possibility execute
> command in my server using "\!" or write one file using "\e".
> I want disable these options in my server but I searched it and not found.

These psql commands run on the client with the privileges of the
client; they don't allow the client to do anything it couldn't
already do from the shell, and presumably the client already has
access to the shell if it's running psql.  This would be a security
problem if you use psql to run SQL statements from an untrusted
source, but if you're doing that then you already have a security
problem.

-- 
Michael Fuhr



view thread (4+ messages)  latest in thread

Message-ID: <20070723141634.GA7388@winnie.fuhr.org>
Permalink:  ../20070723141634.GA7388@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20070723141634.GA7388@winnie.fuhr.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: mike@fuhr.org, malufrj@gmail.com
  Subject: Re: Disable access shell command in psql
  In-Reply-To: <20070723141634.GA7388@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox