I'm running as normal user (not root or database owner). This user has create temporary table priv.
show tables partial: GRANT CREATE TEMPORARY TABLES ON `foobar0`.* TO 'foo'@'localhost' -> (foobar0 and foo are masks for the database name and user, respectively) I created two tmp tables with intermdiate results. I then try to join the 2 tmp tables to a third tmp table and get the following error: ERROR 1142: select command denied to user: '[EMAIL PROTECTED]' for table 'foobar' (foo and foobar are masks for the user and table, respectively). How can I grant a select on a tmp table to the user that created it? I shouldn't have to, should I? I must be missing something obvious. Did I screw up the GRANT CREATE TEMPORARY TABLES statement? Thanks for your time. Pete -- This email may contain CONFIDENTIAL or PRIVILEGED information and is a private communication between the intended addressee and PharMetrics, Inc. If you have received this email in error, reading, copying, using, or disclosing its contents to others is prohibited. Please notify us of the delivery error by replying to this message, and then delete it from your system. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]