Visibility of stored routines content by users

isorokin posted 6 years ago in Feature discussion
I'm having a problem with sharing stored procedures' contents across developers. All of them are allowd to create/modify stored procedures. However if I create a stored procedure its content can not be seen by others. Can anyone give me a hint on what I may do wrong?
Thank you in advance!
ansgar posted 6 years ago
I'm not sure yet why it is empty. I only see another thread with the same issue here.
ansgar posted 6 years ago
Found it:

Both statements require that you be the owner of the routine or have SELECT access to the mysql.proc table. If you do not have privileges for the routine itself, the value displayed for the Create Procedure or Create Function field will be NULL.

They even had a bug report which was closed as this was documented at some point :/
ansgar posted 6 years ago
r4082 modifies the routine editor in Heidi in a way it's disabled if the function code is blank/NULL, including a message label "You have no privilege to this routine".

Please login to leave a reply, or register at first.