Bug #3985 privilege for INSERT, UPDATE, DELETE, DROP, CREATE TEMPORARY TABLES
Submitted: 3 Jun 2004 16:26 Modified: 13 Dec 2005 16:23
Reporter: Timothy Smith Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:4.0 OS:Any (any)
Assigned to: CPU Architecture:Any

[3 Jun 2004 16:26] Timothy Smith
Description:
Right now we have the  CREATE TEMPORARY TABLES privilege.  It is useful, but limited since the user must have INSERT, SELECT, DELETE and UPDATE separately on the database.

It would be nice to have TEMPORARY TABLES, which includes CREATE, DROP, INSERT, UPDATE, SELECT, DELETE and ALTER for temporary tables.

This would be very handy for applications which only do reporting.  E.g., you could grant this privilege on a replication slave server, so that the reporting application could not interfere with replication but could do reports on either the master or the slave w/o any code modifications.

How to repeat:
n/a

Suggested fix:
n/a
[13 Dec 2005 16:23] Valeriy Kravchuk
Thank you for a feature request. There is a similar one already, http://bugs.mysql.com/bug.php?id=2317. I'll mark this one as a duplicate.