TNX, Peter. Should read the stuff better. [off topic: could mysql add a block to the top of each statement: since version, needed plugins, thousands other stuff... ?]
But the problem is not this show-function, it's that I cannot backup the database (the stored routines are empty when I use mysqldump), because I obviously don't have the rights to read the procedure. I don't get it together, because when I read
http://dev.mysql.com/doc/refman/5.1/en/grant.html
I interpret it in the way, that there is no special right to see routines:
"Stored Routine Privileges
The ALTER ROUTINE, CREATE ROUTINE, EXECUTE, and GRANT OPTION privileges apply to stored routines (procedures and functions). They can be granted at the global and database levels. Except for CREATE ROUTINE, these privileges can be granted at the routine level for individual routines."
Nothing about seeing routines. I would prefer not to test this by hand.
Which of the rights are needed to see the stored routine itself, so that backup works?
bye