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.文档反馈