Check requirements: when exporting a view structure, DTS will check whether
user1 corresponding to
[DEFINER = user1]) in the source database is the same as
user2 in the migration target.
SQL SECURITYattribute of
user1in the target database after migration from
[INVOKER = user1]), and set the
DEFINERin the target database to
user2of the migration target (
[DEFINER = migration target user2]).
Check description: the
SQL SECURITY parameter indicates according to whose permissions the system runs the command when a user accesses the specified view.
DEFINER: only the definer can run the command.
INVOKER: only invokers with the invocation permissions can run the command.
DEFINERis specified by the system.
Only a definer that is the same as the migration target's
user@host is allowed; that is, when a view structure is exported, DTS will check whether the
user1 corresponding to the definer in the source database (
[DEFINER = user1]) is the same with the
user2 in the migration target's
user@host, and if yes, the view can be migrated; otherwise, it cannot.
For a definer different from that of the migration target's
user@host, if you want to migrate it, you need to modify the definer in the source database view to the migration target's user, or do not select it during the migration/sync task and then manually sync the view after the task is completed.