View Check
Last updated:2026-02-11 14:55:09
Check Details
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.If they are the same, do not modify the settings after migration.
If they are different, change the
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.
By default, DEFINER is specified by the system.Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback