Re: Anyone can create tables!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: Dan McGrath <dmcgrath19(at)home(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Anyone can create tables!
Date: 2001-03-11 17:22:01
Message-ID: 22557.984331321@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> writes:
> I doubt that I would ever recommend opening any RDBMS to the world.

Indeed. If filling your disk is the only form of denial-of-service
that an attacker can think of, then he's sadly lacking in creativity.

Bottom line for me is that if you're concerned about security then you
should NOT be allowing random people to issue SQL commands directly,
and so this issue isn't nearly as important as Dan makes it.

A more secure arrangement would be (for example) to provide access via
a website backed by CGI or PHP scripts, so that the only possible SQL
commands are those you've put into the scripts.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-11 17:46:28 Re: Strange Message
Previous Message Konstantinos Agouros 2001-03-11 17:20:42 Strange Message