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

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



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;"?





--------------enig4873194B0D5FB7583400C841
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/

iEYEARECAAYFAlBfVJ4ACgkQhmBjz394AnmROwCeJ9ZcEaqqPD/c5Sldn2Sc9eye
jkQAn2yxs/wBQc3xpuWHS8xilUMlr735
=aJy4
-----END PGP SIGNATURE-----

--------------enig4873194B0D5FB7583400C841--