*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 <daevid@stripped> 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
> 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=1
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.