github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/full_mode/data/db2.prepare.user.sql (about)

     1  drop user if exists 'dm_full';
     2  drop role if exists 'test-8.0';
     3  flush privileges;
     4  create user 'dm_full'@'%' identified by '123456';
     5  grant all privileges on *.* to 'dm_full'@'%';
     6  revoke replication slave, replication client, super on *.* from 'dm_full'@'%';
     7  revoke create temporary tables, lock tables, create routine, alter routine, event, create tablespace, file, shutdown, execute, process, index on *.* from 'dm_full'@'%'; # privileges not supported by TiDB
     8  create role 'test-8.0';
     9  grant 'test-8.0' to 'dm_full';
    10  flush privileges;