List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:September 23 2012 6:27pm
Subject:Re: How to block SELECT * FROM table; but not SELECT * FROMT table
WHERE...;
View as plain text  

Am 23.09.2012 20:23, schrieb Luis Daniel Lucio Quiroz:
> Just wondering if is possible to block SELECT queries that doesnt have
> a WHERE statement within.

no and the idea is broken by design

what is wrong with a "select * from table" with small
tbales having only a handful of records?

how will you work with broken "select count(*) from table;"?





Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;Luis Daniel Lucio Quiroz23 Sep
  • Re: How to block SELECT * FROM table; but not SELECT * FROMT tableWHERE...;Reindl Harald23 Sep
  • Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;Tim Pownall23 Sep
    • Re: How to block SELECT * FROM table; but not SELECT * FROMT tableWHERE...;Reindl Harald23 Sep
    • Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;Arthur Fuller23 Sep
      • RE: How to block SELECT * FROM table; but not SELECT * FROMT tableWHERE...;Rick James24 Sep
RE: How to block SELECT * FROM table; but not SELECT * FROMT tableWHERE...;Martin Gainty23 Sep
  • RE: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;abhishek jain24 Sep