tencent cloud

Data Transfer Service

DocumentationData Transfer ServiceData MigrationMigration to MySQL SeriesProcessing for MySQL Series Pre-Check FailureView Check

View Check

PDF
Focus Mode
Font Size
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.
Previous Topic: Foreign Key Dependency CheckNext Topic: Advanced Object Check

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback