Exporting Triggers

[expired user #6882]'s profile image [expired user #6882] posted 6 years ago in Import/Export Permalink

Hi. When exporting stored procedures and triggers to another database, for stored procedures the DEFINER and SQL SECURITY characteristic is exported correctly, but for triggers DEFINER will be reset to the current user-id and the originally defined Property is overwritten. It would be great if for exported triggers also the DEFINER property would be left as given.

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