Table of Contents

Search

  1. About the Test Data Management Configuration Guide
  2. Test Data Management Configuration Overview
  3. Before You Configure Test Data Management
  4. Prepare for Application Services and Databases
  5. Create the Application Services
  6. Configure Test Data Management
  7. Starting and Stopping Informatica Services
  8. Appendix A: Infacmd
  9. Appendix B: Managing Distribution Packages

Configuration Guide

Configuration Guide

Set Up Database User Accounts

Set Up Database User
Accounts

Set up a database and user account for the
repository databases
.
Use the following rules and guidelines when you set up the user
accounts
:
  • The database user account must have permissions to create and drop tables, indexes, and views, and to select, insert, update, and delete data from tables.
  • Use 7-bit ASCII to create the password for the account.
  • To prevent database errors in one repository from affecting any other repository, create each repository in a separate database schema with a different database user account. Do not create a repository in the same database schema as the domain configuration repository or any other repository in the domain.

0 COMMENTS

We’d like to hear from you!