User privileges for performance assessment

During performance assessment, different privileges are required based on the replay type.

• When creating a performance assessment task, select Replay Type as Read Traffic (DQL) on the Configure Workload Replay page. The required privileges for the replay user are as follows:

  GRANT SELECT ON <database_name>.* TO '<username>';
  

• When creating a performance assessment task, select Replay Type as Write Traffic (DML) on the Configure Workload Replay page. The required privileges for the replay user are as follows:

  GRANT INSERT, DELETE, UPDATE ON <database_name>.* TO '<username>';