Table of Contents

Search

  1. Pre-Installation
  2. Installation
  3. Post-Installation
  4. Apply the HotFix
  5. Starting and Stopping Proactive Monitoring Components
  6. Logging In to Client Tools
  7. Configure Reporting
  8. Installation and Configuration Checklist

Installation Guide

Installation Guide

Create a Read-only User in Oracle

Log in to the PowerCenter repository database as the database owner and perform the following tasks:
  • Create a read-only user, for example
    pcrs_readonly
    .
  • Grant the following privileges to the user:

      ALTER TABLE

      CREATE INDEX

      CREATE SESSION

      CREATE SYNONYM

      CREATE TABLE

      CREATE VIEW

      INSERT INTO TABLE

If you are going to monitor the Informatica environment for operations, perform the following task:
  • Log in as "sys as sysdba" and run the following commands:
    grant select on sys.dba_free_space to <read only user name>; grand select on sys.dba.data_files to <read only user name>