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 2. Create a User

Step 2. Create a User

Create a user that you can use to create and access the
Identity Resolution
tables and database objects. IBM DB2 UDB uses the external authentication mechanism, so you can use the operating system to create the user.
By default,
Identity Resolution
uses the load utility of IBM DB2 UDB to move large quantities of data into newly created tables. You must have the SYSADM or DBADM authority to run the load utility.
The following table describes the authorities that you must grant the user:
Database Type
Authority
Source database without synchronization
CONNECT
Target database without synchronization
CONNECT
CREATETAB
LOAD
Source database with synchronization
CONNECT
CREATETAB
LOAD
Target database with synchronization
CONNECT
CREATETAB
LOAD
ALTER