tencent cloud

Feedback

View Check

Last updated: 2024-07-08 19:41:52

    MySQL/TDSQL-C 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.

    TDSQL for MySQL Check Details

    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.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support