Cant get "grant execute on procedure" to work.

  • Follow


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


0 Replies
531 Views

(page loaded in 0.027 seconds)

Similiar Articles:













7/24/2012 8:36:53 AM


Reply: