I have a WEIRD question, that I can't find an answer too...
Here is my stored function:
DROP FUNCTION IF EXISTS `SPLIT_STR`$$
CREATE DEFINER=`thisuser`@`%` FUNCTION `SPLIT_STR`(
) RETURNS VARCHAR(255) CHARSET latin1
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(X, delim, pos),
LENGTH(SUBSTRING_INDEX(X, delim, pos -1)) + 1),
Basically, as it sits, only the user 'thisuser' at any location can use this
function, but I want to be able to allow ALL the users of this database
access to it, as well, if I were to change this function, i have to go in,
and manage every user that would be attached to it, to allow to use it
I've tried '%'@'%', and I get the error that this user does not exist.
Any help? Is it possible?
|• Stored Procedure/Function Question||Steve Staples||17 Feb|