有没有更好的方法为MySQL中的临时表分配权限？

GRANT SELECT, INSERT, UPDATE, DELETE ON TEMPORARY TABLES TO 'john';

CREATE TEMPORARY TABLE temp_table (
    id INT PRIMARY KEY,
    name VARCHAR(50)
) WITH GRANT OPTION;

CREATE PROCEDURE create_temp_table()
BEGIN
    CREATE TEMPORARY TABLE temp_table (
        id INT PRIMARY KEY,
        name VARCHAR(50)
    );
    GRANT SELECT, INSERT, UPDATE, DELETE ON TEMPORARY TABLES TO 'john';
END;

CALL create_temp_table();