Q: mysql temporary table privileges I am using mariadb as my application backend.
i need to create a temporary table (which is temporary per connection, so when the connection is lost it will gone; that is what i want), but i need store a value which should be constant so the user only read it (no update, delete or ... only select), and this value is different in every connection.
so my question is can i grant only select privilege on a specific temporary table in mysql or mariadb?

A: according to the MySQL 5.1 Documenation https://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_create-temporary-tables, it can't be done. 
in the documentation it is suggested to use another database dedicated to temporary tables, with specified privilege for it.
