Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing MDM Registry Edition
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading MDM Registry Edition
  7. Uninstalling MDM Registry Edition

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
MDM Registry Edition
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,
MDM Registry Edition
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