I have a user that I have already permission to be able to CREATE a temporary table, however when she tries to load a csv file into that temporary table, we’re getting a restricted access error for loading. In general, she is not permissioned to load a csv file into any real tables. I only want her to be able to load data into any temporary table she wants. How can I achieve this?
1
You will likely need to grant insert/load permissions on the table. You may need to try this:
-- Grant INSERT or LOAD privileges on temporary tables
GRANT INSERT, LOAD ON your_database_name.your_temporary_table TO 'your_user_name'@'your_host_name';