View Single Post

   
  #1 (permalink)  
Old 04-29-2008, 08:28 PM
Chuck
 
Posts: n/a
Default querying the grant tables

-----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-----
Reply With Quote