distal-attribute
distal-attribute
distal-attribute
distal-attribute

Visibility of stored routines content by users

User, date Message
Written by isorokin
3 years ago
Category: Feature discussion
1 posts since Wed, 07 Mar 12
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!
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
I'm not sure yet why it is empty. I only see another thread with the same issue here.
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
Found it:
http://dev.mysql.com/doc/refman/5.1/en/show-create-procedure.html

mysqldocs wrote: 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 :/
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
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.