-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I'm a little fuzzy on the exact meanings of the columns in the grant
tables and the docs at mysql.com aren't very clear either. Is there a
query I can write to determine who has the ability to run "drop database"?
Would it be this?
select host,user
from mysql.user
where drop_priv = 'Y';
Searching the docs for "drop_priv" brings up a page that lumps together
the column defs for several of the grant tables but doesn't clearly
state whether mysql.user.drop_user is for "drop table", "drop database",
or both.
TIA
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with PCLinuxOS -
http://enigmail.mozdev.org
iEYEARECAAYFAkgXgWcACgkQzIf+rZpn0oTcsgCdEyHktE09Kr 0u5d2FwfNm/Kk9
cE4An3bt7ZHUbHskLRyZC5xzWVEYreE+
=bcyw
-----END PGP SIGNATURE-----