Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A98469FB5E6 for ; Mon, 23 Jul 2007 11:31:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 52278-10 for ; Mon, 23 Jul 2007 11:31:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.235]) by postgresql.org (Postfix) with ESMTP id 1EAA29FB6EF for ; Mon, 23 Jul 2007 11:31:11 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 25so1013902wry for ; Mon, 23 Jul 2007 07:31:09 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=rSIxZplgpynrAXiybAqYlp6LnnXCv20S9cnsNwHAmCCnxKQ/DTqqnyKmYWzkiUvfoPYrzFe3prCT3oVVjZBeAF2FaQQJ4HAuVROimzhCa/TMf+XqR0c28cAkacBnUQjukSP0MfVar1Ef8glI8RWtmnUz/VhEthhsMEP2sX28oZc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=La6MS4A7QUnH02SXcAADrNj7KGo3Lk0/q7AnV6egEm7w+OzLTA6B21GEQ/n7DgYMpjkrQTiNN76fxVrF3cbk7TtMA/CGtx5Wl+tV0C7k8jUe+n6wkMthgjMg5XN8TC6PtMZ7qZY3kZUAb51JGw50cuMjTmDxxcRC13Rhy7y2Pic= Received: by 10.142.77.11 with SMTP id z11mr238835wfa.1185201069160; Mon, 23 Jul 2007 07:31:09 -0700 (PDT) Received: by 10.142.84.10 with HTTP; Mon, 23 Jul 2007 07:31:09 -0700 (PDT) Message-ID: Date: Mon, 23 Jul 2007 11:31:09 -0300 From: "Thiago Maluf" To: "Tom Lane" Subject: Re: Disable access shell command in psql Cc: pgsql-admin@postgresql.org In-Reply-To: <24056.1185200785@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_126885_26547666.1185201069131" References: <24056.1185200785@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/246 X-Sequence-Number: 26227 ------=_Part_126885_26547666.1185201069131 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I`m sorry list. I had one mistake. Thanks for everyone. Thiago 2007/7/23, Tom Lane : > > "Thiago Maluf" writes: > > 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". > > These are done on the client side, not the server side. There is no > security issue here, because psql's user could equally well do the > same things without using psql. > > regards, tom lane > -- ---------------------------------------------------------------- THIAGO MALUF RESENDE Consultor Voip e Programador WEB (Voip Developer and Web Developer) Tel: +55 21 86042100 e-mail: malufrj@gmail.com ------=_Part_126885_26547666.1185201069131 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I`m sorry list.
I had one mistake.
Thanks for everyone.
Thiago

2007/7/23, Tom Lane <tgl@sss.pgh.pa.us>:
"Thiago Maluf" <malufrj@gmail.com> writes:
> 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".

These are done on the client side, not the server side.  There is no
security issue here, because psql's user could equally well do the
same things without using psql.

                        regards, tom lane



--
----------------------------------------------------------------
THIAGO MALUF RESENDE
Consultor Voip e Programador WEB (Voip Developer and Web Developer)
Tel: +55 21 86042100
e-mail: malufrj@gmail.com ------=_Part_126885_26547666.1185201069131--