469,081 Members | 1,882 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

Alpha 4.1 - Temporary Tables Question

I'm running as normal user (not root or database owner). This user has c=
reate=20
temporary table priv.

show tables partial:
GRANT CREATE TEMPORARY TABLES ON `foobar0`.* TO 'foo'@'localhost' -> (foo=
bar0=20
and foo are masks for the database name and user, respectively)

I created two tmp tables with intermdiate results. I then try to join th=
e 2=20
tmp tables to a third tmp table and get the following error:
ERROR 1142: select command denied to user: 'foo@localhost' for table 'foo=
bar'=20
(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=20
shouldn't have to, should I? I must be missing something obvious. Did I=
=20
screw up the GRANT CREATE TEMPORARY TABLES statement?

Thanks for your time.
Pete
--=20
This email may contain CONFIDENTIAL or PRIVILEGED information and is a pr=
ivate=20
communication between the intended addressee and PharMetrics, Inc. If you=
=20
have received this email in error, reading, copying, using, or disclosing=
its=20
contents to others is prohibited. Please notify us of the delivery error =
by=20
replying to this message, and then delete it from your system. Thank you.=
=20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1978

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Peter Gorelczenko | last post: by
4 posts views Thread by gonzal | last post: by
2 posts views Thread by airkart | last post: by
8 posts views Thread by Martijn van Oosterhout | last post: by
1 post views Thread by Stefan van Roosmalen | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.