Hi there,
I have a WEIRD question, that I can't find an answer too...
Here is my stored function:
DELIMITER $$
USE `mydatabase`$$
DROP FUNCTION IF EXISTS `SPLIT_STR`$$
CREATE definer=`thisus...@`%` FUNCTION `SPLIT_STR`(
X VARCHAR(255),
delim VARCHAR(12),
pos INT
) RETURNS VARCHAR(255) CHARSET latin1
DETERMINISTIC
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(X, delim, pos),
LENGTH(SUBSTRING_INDEX(X, delim, pos -1)) + 1),
delim, '')$$
DELIMITER ;
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
again.
I've tried '%'@'%', and I get the error that this user does not exist.
Any help? Is it possible?
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
