pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDisable access shell command in psql
4+ messages / 3 participants
[nested] [flat]
* Disable access shell command in psql
@ 2007-07-23 13:59 Thiago Maluf <malufrj@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Thiago Maluf @ 2007-07-23 13:59 UTC (permalink / raw)
To: pgsql-admin
Hello to everyone,
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.
Can someone help me, please ?
very thanks,
Thiago
----------------------------------------------------------------
THIAGO MALUF RESENDE
Consultor Voip e Programador WEB (Voip Developer and Web Developer)
Tel: +55 21 86042100
e-mail: malufrj@gmail.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Disable access shell command in psql
@ 2007-07-23 14:16 Michael Fuhr <mike@fuhr.org>
parent: Thiago Maluf <malufrj@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Michael Fuhr @ 2007-07-23 14:16 UTC (permalink / raw)
To: Thiago Maluf <malufrj@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Disable access shell command in psql
@ 2007-07-23 14:26 Tom Lane <tgl@sss.pgh.pa.us>
parent: Thiago Maluf <malufrj@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Tom Lane @ 2007-07-23 14:26 UTC (permalink / raw)
To: Thiago Maluf <malufrj@gmail.com>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Disable access shell command in psql
@ 2007-07-23 14:31 Thiago Maluf <malufrj@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Thiago Maluf @ 2007-07-23 14:31 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-07-23 14:31 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-23 13:59 Disable access shell command in psql Thiago Maluf <malufrj@gmail.com>
2007-07-23 14:16 ` Michael Fuhr <mike@fuhr.org>
2007-07-23 14:26 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-07-23 14:31 ` Thiago Maluf <malufrj@gmail.com>
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