ERROR 1290 (HY000): The MariaDB server is running with the --read-only option so it cannot execute this statement

-- Log in as a super user

set global read_only=ON;

use test;

create table test_tbl(a int);

create user test_user@localhost identified by 'NotSecure';

grant insert, select, update, delete, create temporary tables on test.* to test_user@localhost;

insert into test_tbl select * from seq_1_to_5;

-- Log in as the limited privledge user mariadb -u test_user -pNotSecure test

create temporary table tmp_test_tbl as select * from test_tbl;  -- error will be thrown here

select * from tmp_test_tbl; -- 10.6 & higher return results 10.5 has an empty table

create temporary table tmp_test_tbl2 like test_tbl;   -- This succeeds with no error

insert into tmp_test_tbl2 select * from test_tbl -- This succeeds with no error

select * from tmp_test_tbl2; -- This returns data