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

i am not permited to view my functions

ramico posted 2 years ago in General
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
ansgar posted 2 years ago
> it then says i'm not permuted to view it

When exactly does "it" say that?
ramico posted 2 years ago
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'





jfalch posted 2 years ago
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 ?
ramico posted 2 years ago
click the blue icon play i usually do that
or right click run selection when needed 'rare condition'
ramico posted 2 years ago
https://fbcdn-sphotos-e-a.akamaihd.net/hphotos-ak-ash3/812782_10151327861875326_308815839_o.jpg
ramico posted 2 years ago
no error i just can't edit it as usual
ansgar posted 2 years ago
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.
ansgar posted 2 years ago
Oh this is tricky to fix. I recently fixed another bug and opened this one instead.
ramico posted 2 years ago
That fixed the issue Thank you smile
ansgar posted 2 years ago
Should be fixed in r4326. information_schema.ROUTINES.ROUTINE_DEFINITION is asked as an alternative way now.
ansgar posted 2 years ago
That means - you should now be able to leave the BEGIN..END block away, should work with or without these.
ramico posted 2 years ago
i updated it and now it works as expected i'm very happy

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