ERROR 1370 (42000): execute command denied to user 'wwwrun'@'%' for
routine 'GasCheck.CreateTid'
To get here I've got the following setup on ubuntu 10.04 using mysql
5.1.41-3ubuntu12.6 :
mysql> select user(), current_user();
+------------------+----------------+
| user() | current_user() |
+------------------+----------------+
| wwwrun@localhost | wwwrun@% |
+------------------+----------------+
select * from mysql.procs_priv;
+------+----------+--------+--------------+--------------
+-----------------+-----------+---------------------+
| Host | Db | User | Routine_name | Routine_type |
Grantor | Proc_priv | Timestamp |
+------+----------+--------+--------------+--------------
+-----------------+-----------+---------------------+
| % | GasCheck | wwwrun | CreateTid | PROCEDURE |
peter@localhost | Execute | 2010-08-09 16:05:51 |
+------+----------+--------+--------------+--------------
+-----------------+-----------+---------------------+
My GRANT command was as follows
grant execute on procedure GasCheck.CreateTid to wwwrun@'%';
I dont have anonymous logins.
mysql> select user,host from mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| peter | % |
| wwwrun | % |
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| phpmyadmin | localhost |
| root | localhost |
| root | peter |
+------------------+-----------+
Is this a bug? or am I missing something obvious?
Maybe I'll just switch back to Sybase which has had this feature for
20 years.
|
|
0
|
|
|
|
Reply
|
sybaseguru
|
8/9/2010 4:25:47 PM |
|