Re: Re: Anyone can create tables! - Mailing list pgsql-general

From Richard Huxton
Subject Re: Re: Anyone can create tables!
Date
Msg-id 3AADD060.CDB802C@archonet.com
Whole thread Raw
In response to Re: Re: Anyone can create tables!  (martin.chantler@convergys.com)
List pgsql-general
martin.chantler@convergys.com wrote:
>
> I have not been following the start of this thread but I was myself
> wondering about the security of DB access over the web
[snip]
> You could then left them do things, even enter SQL into your form but your
> servlet
> could parse it and stop them doing unwanted things.
>
> BTW Are there any security issues with this that anyone knows of???
>
There are security issues with anything, but the crucial thing is to be
strict with the parsing. Choose what to let through rather than what to
block. One trick is to pass crafted text in to value fields in forms to
force your own query to run.

Buffer overflows etc should presumably be less of a problem with Java.

- Richard Huxton

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: varchat ->text
Next
From: Richard Huxton
Date:
Subject: Re: display temp table structure?