i am not permited to view my functions
| User, date | Message |
|---|---|
|
Written by ramico
4 months ago Category: General 11 posts since Thu, 07 Feb 13 |
i log in as root i create a one line function it then says i'm not permuted to view it i can execute show create function |
|
Written by ansgar
4 months ago 4020 posts since Fri, 07 Apr 06 |
> it then says i'm not permuted to view it When exactly does "it" say that? |
|
Written by ramico
4 months ago 11 posts since Thu, 07 Feb 13 |
ok i connect 'very typically' i go to query tab i type create function fn_df(d date) returns varchar(20) return date_format(d,'%d/%b/%Y') i go to the DBs pane refresh on functions group click the func open the function on the right next to the buttons help, discard and save 'you have no privileges to view this routine' |
|
Written by jfalch
4 months ago 241 posts since Sat, 17 Oct 09 |
after writing the above "create function" statement, did you execute it ? ("Run" from query pane context menu, or F9) just curious.. then, assuming that your last sentence means "click the func >will< open the function on the right next to the buttons ..." what happens before the error message ? what exactly happens when you click the function name ? screenshot ? |
|
Written by ramico
4 months ago 11 posts since Thu, 07 Feb 13 |
click the blue icon play i usually do that or right click run selection when needed 'rare condition' |
|
Written by ramico
4 months ago 11 posts since Thu, 07 Feb 13 |
https://fbcdn-sphotos-e-a.akamaihd.net/hphotos-ak-ash3/812782_10151327861875326_308815839_o.jpg |
|
Written by ramico
4 months ago 11 posts since Thu, 07 Feb 13 |
no error i just can't edit it as usual |
|
Written by ansgar
4 months ago 4020 posts since Fri, 07 Apr 06 |
Ah, got it. HeidiSQL assumes a privilege error when the body of the routine is empty. It is not really empty in your case, but it is not surrounded by a BEGIN...END, which HeidiSQL expects. So, it turns out as a bug in HeidiSQL. Please try to confirm that, by adding the mentioned BEGIN/END. |
|
Written by ansgar
4 months ago 4020 posts since Fri, 07 Apr 06 |
Oh this is tricky to fix. I recently fixed another bug and opened this one instead. |
|
Written by ramico
4 months ago 11 posts since Thu, 07 Feb 13 |
That fixed the issue Thank you 
|
|
Written by ansgar
4 months ago 4020 posts since Fri, 07 Apr 06 |
Should be fixed in r4326. information_schema.ROUTINES.ROUTINE_DEFINITION is asked as an alternative way now. |
|
Written by ansgar
4 months ago 4020 posts since Fri, 07 Apr 06 |
That means - you should now be able to leave the BEGIN..END block away, should work with or without these. |
|
Written by ramico
4 months ago 11 posts since Thu, 07 Feb 13 |
i updated it and now it works as expected i'm very happy |
|
Please login to leave a reply, or register at first. |
