*shrugs* I, for one, appreciate a tool that doesn't try to be smarter than I am. If I want to be treated like an idiot, I'll use microsoft software.
On Wed, May 27, 2009 at 2:38 AM, Daevid Vincent <dae...@daevid.com> wrote: > I'm a little concerned and disappointed that the GRANT command doesn't do > any sort of checking (like a foreign key for example) to verify that the > database and table exist?! > > I get the case of *.* but it seems crazy to me that it would allow foo.bar > when neither a database named 'foo' nor a table named 'bar' even exist?!?! > > Clearly the GRANT command is a special case/tool that should have this > ability and throw an error or prevent this. > > If for some reason, this blind insertion is needed for some flexibility say > with temporary tables or something that doesn't exist, then perhaps that > should be a switch/parameter to the command to 'over-ride' the checking and > allow the GRANT (after all, it's just an insert/update/delete statement > when > it all boils down to the mysql.user table). In fact, that COULD be the way > these "special case people" get around using GRANT, just insert what they > want directly into mysql.user,host,table, etc. and FLUSH PRIVILEGES. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > -- Celsius is based on water temperature. Fahrenheit is based on alcohol temperature. Ergo, Fahrenheit is better than Celsius. QED.