Remove definer attribute

mcemberci's profile image mcemberci posted 4 weeks 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 4 weeks 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 4 weeks 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 4 weeks 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.

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