From: Reindl Harald
Date: September 23 2012 7:57pm
Subject: Re: How to block SELECT * FROM table; but not SELECT * FROMT table
 WHERE...;
List-Archive: http://lists.mysql.com/mysql/228238
Message-Id: <505F69B2.3070605@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig0E6609D80C4C52354DD28CA4"

--------------enig0E6609D80C4C52354DD28CA4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

that does not change the fact that it is valid to NOT have a where
statement and for me it sound plain  stupid to think about blocking
queries without where-statements - the application developers will
hopefully kill any admin who finds a solution for this...........

* i maintain a cms-system since 10 years
* mainmenu: select id,title from table order by sortfield;
* and YES in the backend the is no single reson to reduce the result
* and NO using a key would not make anything faster

so why would there be a WHERE make any sense and why does
someone like to break the application just for fun?

Am 23.09.2012 21:50, schrieb Tim Pownall:
>  select * from table where column=3Dvalue means it will return only row=
s that
> match.  as long as you have proper indexing there should not be any iss=
ues.
>=20
> On Sun, Sep 23, 2012 at 1:23 PM, Luis Daniel Lucio Quiroz <
> luis.daniel.lucio@stripped> wrote:
>=20
>> Helo,
>>
>> Just wondering if is possible to block SELECT queries that doesnt have=

>> a WHERE statement within.


--------------enig0E6609D80C4C52354DD28CA4
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlBfabIACgkQhmBjz394AnntBQCfV3gMYzpo4dGZMAeCSAPSo2Iy
TxIAn3glRvOK232qPH2IU6o3LJnwUU4f
=cXC4
-----END PGP SIGNATURE-----

--------------enig0E6609D80C4C52354DD28CA4--