Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing Identity Resolution
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading Identity Resolution
  7. Uninstalling Identity Resolution

Installation and Configuration Guide

Installation and Configuration Guide

Step 1. Create a User

Step 1. Create a User

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