Jump to content

Recommended Posts

Posted

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... 

  Quote

#1142 - SELECT command denied to user 'kanvull_main'@'localhost' for table `dbo`.`random_text_answer`

i wanted to try to check "Adjust privileges" in edit window, but this checkbox is unactive..

What should I do in this case?

  • kanvull changed the title to SQL-priviledges issue
Guest
This topic is now closed to further replies.
×
×
  • Create New...