릴리스 노트
user1 corresponding to DEFINER ([DEFINER = user1]) in the source database is the same as user2 in the migration target.SQL SECURITY attribute of user1 in the target database after migration from DEFINER to INVOKER ([INVOKER = user1]), and set the DEFINER in the target database to user2 of the migration target ([DEFINER = migration target user2]).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.
By default, DEFINER is specified by the system.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.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.피드백