Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Before You Install
  4. Data Archive Installation
  5. Data Vault Installation
  6. Application Accelerator Installation
  7. Application Retirement for Healthcare Accelerator Installation
  8. Salesforce Accelerator Installation
  9. After You Install
  10. Data Archive Upgrade
  11. Data Vault Upgrade
  12. Upgrading Oracle History Data
  13. Upgrading PeopleSoft History Data
  14. ILM Data Validation Option Setup
  15. Data Archive Source and Target Database Requirements
  16. Data Archive Connectivity
  17. Data Archive Uninstallation
  18. SAP Application Retirement
  19. Database Users and Privileges
  20. Data Visualization Designer Installation
  21. Data Archive Installation Requirements Checklist and Architecture Options

Installation and Upgrade Guide

Installation and Upgrade Guide

History Application User

History Application User

The history application user owns all of the archive tables and resides on the target database.

Required Privileges

The following table lists the user privileges that the history application user requires:
Oracle Privileges
Microsoft SQL Server Privileges
IBM DB2 Privileges
ALTER SESSION
ALTER EVENT SESSION
ALTER SESSION
CREATE DATABASE LINK
Not applicable
Not applicable
CREATE PROCEDURE
CREATE PROCEDURE
CREATE PROCEDURE
CREATE SEQUENCE
CREATE SEQUENCE
CREATE SEQUENCE
CREATE SESSION
CREATE EVENT SESSION
CREATE EVENT SESSION
CREATE SYNONYM
CREATE SYNONYM
CREATE SYNONYM
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE VIEW
CREATE VIEW
CREATE VIEW

IBM DB2 Privileges

If you use the IBM DB2 load client utility or the import utility to insert data into the history database, then the history application user requires load and insert privileges.

Restore Privileges

When you restore archived data, the history application user functions like the production application user during an archive cycle. To restore archived data, the history application user requires the SELECT ANY TABLE privilege.

0 COMMENTS

We’d like to hear from you!