Create a schema for Identity Resolution. After you create a schema, create a user for the schema that you can use to create and access the Identity Resolution tables and database objects. Grant all the required privileges to the user.

For example, the following commands create a schema,

ssa

, creates a user,

ssa

, and grant all the permissions to the user:

create schema ssa;
use ssa;
create user 'ssa'@'%' identified by 'ssa';
grant all on ssa.* to 'ssa'@'%';

The following table describes the privileges that you must grant the user:

Database Type	Privilege
Source database without synchronization	SELECT
Target database without synchronization	SELECT CREATE DELETE DROP EXECUTE INSERT LOCK TABLES UPDATE
Source database with synchronization	SELECT CREATE DELETE DROP EXECUTE INSERT LOCK TABLES UPDATE TRIGGER
Target database with synchronization	SELECT CREATE DELETE EXECUTE DROP INSERT LOCK TABLES UPDATE TRIGGER