Jim, You might check page 41 of this document
http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.pdf it's all I have found so far. with Best Regards, Mike ----- Original Message ----- From: Jim To: [email protected] Sent: Monday, July 10, 2006 1:10 PM Subject: [php_mysql] MySQL 5 and stored procedures Hi Peeps, I am running MySQL 5 on Suse 9 (I believe it's 9) and I have created system users and, as root, have granted all privileges to all of these users. I am not worried about security because this is a teaching situation, not production. Telnetted in, all users can create databases, tables and triggers. However, they cannot create procedures or functions, only the root account can. The general users can execute procedures written by the root, but cannot create them. Any idea where this restriction resides? Any help would be appreciated. Thanks, Jim [Non-text portions of this message have been removed] The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
