Hi there, I'm trying to restrict the access that a Tomcat server has to mysql 4.0.15-standard-log database server. Unfortunately some of the queries use temporary tables, so I've had to GRANT CREATE TEMPORARY TABLES to the user.
However, since the server is using connection pooling, it also DROPS the temporary tables after the queries have completed. I'd really like to be able to GRANT DROP TEMPORARY TABLES, but this doesn't seem to exist, so I've got to GRANT DROP - which feels a less safe to me :( Is there a better way of doing this that someone has found before, or is there a way to grant DROPS of the temporary table? Many Thanks, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
