Visibility of stored routines content by users

1 posts
[expired user #6275]'s profile image [expired user #6275] posted 12 years ago in Feature discussion Permalink
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!
10151 posts
ansgar's profile image ansgar posted 12 years ago Permalink
I'm not sure yet why it is empty. I only see another thread with the same issue here.
10151 posts
ansgar's profile image ansgar posted 12 years ago Permalink
Found it:
http://dev.mysql.com/doc/refman/5.1/en/show-create-procedure.html

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 :/
Code modification/commit from ansgar.becker, 12 years ago, revision 7.0.0.4082
Disable editing routines if user has no privilege to select from mysql.proc or if he's not the owner of that routine. See http://www.heidisql.com/forum.php?t=10231
10151 posts
ansgar's profile image ansgar posted 12 years ago Permalink
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.