Remove definer attribute

mcemberci's profile image mcemberci posted 12 months ago in General Permalink

Hi, Although remove definer is checked, stored procedure definer definitions still appear when copying to a different database with export.

ansgar's profile image ansgar posted 12 months ago Permalink

Not the case here - definer clause is left away when I export a procedure to a different database.

Please ensure you're using the latest version, and probably post a more detailed reproduction recipe.

mcemberci's profile image mcemberci posted 12 months ago Permalink

I'm using v12.10.0.7023

This is source db image.png

This is export settings image.png

This is destination db image.png

ansgar's profile image ansgar posted 12 months ago Permalink

I suppose the definer "can@%" is the one which you are using to connect, and MySQL sets it silently?

You should examine the CREATE code in the log panel.

enkodellc's profile image enkodellc posted 7 months ago Permalink

I want to create a stored procedure with MariaDB and have no definer set. HeidiSql automatically seems to set this and it is quite frustrating because I want to give some readonly users access to alter stored procedures only but this blocks them.

ansgar's profile image ansgar posted 7 months ago Permalink

You should be able to remove the definer in the edit box, no?

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