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

i am not permited to view my functions

User, date Message
Written by ramico
1 year 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
1 year ago
4936 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
1 year 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 jfalchMoney, Euro
1 year ago
380 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
1 year 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
1 year 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
1 year ago
11 posts since Thu, 07 Feb 13
no error i just can't edit it as usual
Written by ansgar
1 year ago
4936 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
1 year ago
4936 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
1 year ago
11 posts since Thu, 07 Feb 13
That fixed the issue Thank you smile
Written by ansgar
1 year ago
4936 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
1 year ago
4936 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
1 year 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.