Mysql存储过程根据以下参数之一创建用户并授予权限

DELIMITER //

CREATE PROCEDURE CreateUserAndGrantPermissions(
    IN username VARCHAR(50),
    IN password VARCHAR(50),
    IN database_name VARCHAR(50),
    IN table_name VARCHAR(50),
    IN permission_type VARCHAR(20)
)
BEGIN
    -- 创建用户
    SET @create_user_sql = CONCAT('CREATE USER ', username, '@\'%\' IDENTIFIED BY \'', password, '\'');
    PREPARE create_user_stmt FROM @create_user_sql;
    EXECUTE create_user_stmt;
    DEALLOCATE PREPARE create_user_stmt;

    -- 授予权限
    SET @grant_permission_sql = CONCAT('GRANT ', permission_type, ' ON ', database_name, '.', table_name, ' TO ', username, '@\'%\'');
    PREPARE grant_permission_stmt FROM @grant_permission_sql;
    EXECUTE grant_permission_stmt;
    DEALLOCATE PREPARE grant_permission_stmt;
END //

DELIMITER ;