Bug #14401 One should have full privileges to temporary tables without having global ones
Submitted: 27 Oct 2005 16:18 Modified: 26 Jul 2009 16:51
Reporter: Stephan Hasler Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.7 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[27 Oct 2005 16:18] Stephan Hasler
Please consider to allow full privileges to temporary tables created by a certain user. Until now the user needs global DELETE-, INSERT-, .. privileges to manipulate his own temporary tables. Or, alternatively, introduce for all privileges a variation for temporary tables as it was done for the create table statement.

How to repeat:
Give a user only the global create temporary table privilege. Let the user create a temporary table. He will not be able to add new entries with the insert command.
You can only allow this by giving him the global insert privilege. But then he can manipulate permanent tables also, which is not desired.
[26 Jul 2009 16:51] Valeriy Kravchuk
Let's consider this as a duplciate of Bug #27480 (that is already escalated and have many other duplicates).