Give ordinary users the ability to lock (LOCK) tables, create temporary tables, and execute stored procedures. : Temporary Table « Table Index « SQL / MySQL






  1. SQL / MySQL
  2. Table Index
  3. Temporary Table

Give ordinary users the ability to lock (LOCK) tables, create temporary tables, and execute stored procedures.

     

GRANT Lock Tables, Create Temporary Tables, Execute ON forum.*
TO forumuser@localhost








Related examples in the same category

1.Using Temporary Tables
2.Copying to a Temporary Table
3.Creating Temporary Tables
4.A temporary table can be created by adding the keyword TEMPORARY to the CREATE TABLE statement:
5.CREATE TEMPORARY TABLE
6.Duplicate table name between normal table and temporary table
7.Memory engine for temporary table
8.Create a TEMPORARY TABLE;