Re: Limit on number of queries from CGI or PHP (security) - Mailing list pgsql-general

From Alfred Perlstein
Subject Re: Limit on number of queries from CGI or PHP (security)
Date
Msg-id 20001017012804.S272@fw.wintelcom.net
Whole thread Raw
In response to Limit on number of queries from CGI or PHP (security)  (Rikul Patel <rikul7@yahoo.com>)
List pgsql-general
* Rikul Patel <rikul7@yahoo.com> [001017 01:07] wrote:
> Hi,
>
> Is there any way I can restrict number of queries to
> only one? Here's the problem:
>
> If PHP script gets some data as input from user, and
> PHP scripts tries to put this data into Postgresql,
> what's keeping the user to modify the data in way to
> have postgresql execute two queries.
>
> So instead of some PHP script generating query like
> "select * from table where text='some text' or id=1",
> some malicious user could make it generate "select *
> from table where text='some text' or id=1;delete from
> table"

see php's addslashes() function.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-general by date:

Previous
From: AGRE Enterprises
Date:
Subject: Stumped on PlPgSql
Next
From: Gilles DAROLD
Date:
Subject: Re: PL/Perl compilation error