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. MongoDB Accelerator Installation
  9. Salesforce Accelerator Installation
  10. After You Install
  11. Data Archive Upgrade
  12. Data Vault Upgrade
  13. Upgrading Oracle History Data
  14. Upgrading PeopleSoft History Data
  15. ILM Data Validation Option Setup
  16. Data Archive Source and Target Database Requirements
  17. Data Archive Connectivity
  18. Data Archive Uninstallation
  19. SAP Application Retirement
  20. Database Users and Privileges
  21. Data Visualization Designer Installation
  22. 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!