MySQL Bugs: #14401: One should have full privileges to temporary tables without having global ones

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:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.0.7	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any

Description:
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.

Let's consider this as a duplciate of Bug #27480 (that is already escalated and have many other duplicates).