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