Hello all, I have created a user account which has privileges granted at very local levels i.e. privileges for specific database tables. I also have a requirement for this same account to create TEMPORARY tables, which is no problem at all. However, when it comes to viewing data in temporary tables access is denied as the account has no global privileges and it's not possible (as far as I know) to grant SELECT or INSERT privileges on temporary tables for the SQL account. So far I can only get round this problem by granting database GLOBAL privileges for the account, but I would really prefer to grant only table specific privileges if possible. Anyone have any suggestions ?