Check requirements: when exporting a view structure, DTS will check whether 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]
).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.DEFINER
is 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.
Was this page helpful?