so, why can a user do USE MYSQL when he has CREATE
TEMPORARY TABLES?
Well, after reading their answer, I guess we will have to rely on something else to set $is_superuser, like selecting records from mysql.user.
Marc
well, finally i do have MySQL 4.0.12 on my server here, so i am starting to read the list again.
I think MySQLs Behaviour is correct here - you have a global privilege (even if it doesn't give you any useful right), so you have that for all Databases, so you can view it...
What i think does not make any sense is that on upgrading from 3.23, when you run their script to update your rights users that didn't have ANY global rights before automatically get a global 'create temporary table' and 'lock tables'. if you remove that two global privileges everything works as we expect it again. so the question is: is that a bug with the upgrade script? regards
Mike Beck