Hi. I'm trying to figure out how functions and procedures works into MariaDB. And i creared a sinple function:
BEGIN
declare ans TEXT;
select answer into ans from text_answers ORDER by rand() limit 1;
RETURN ans;
END
and wanted to call this function by:
SELECT * from dbo.random_text_answer
but i've got a error of loss privileges...
i wanted to try to check "Adjust privileges" in edit window, but this checkbox is unactive..
What should I do in this case?