Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Combined User and Archive User for Seamless Access

Combined User and Archive User for Seamless Access

The combined user and archive user have query-only access to archived data. The users are required for seamless access for combined and history data. The combined user has access to view both the current and history data. The archive user has access to view the history data.
For Oracle, PeopleSoft, and Siebel applications, create both users on the production database for performance reasons.
Both users require the following user privileges:
Oracle Privileges
Microsoft SQL Server Privileges
IBM DB2 Privileges
ALTER SESSION
ALTER EVENT SESSION
ALTER SESSION
CREATE CLUSTER
CREATE CLUSTER
Use the Create Cluster wizard.
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 VIEW
CREATE VIEW
CREATE VIEW
EXECUTE ANY PROCEDURE
EXECUTE PROCEDURE
SELECT ANY SEQUENCE
SELECT SEQUENCE
SELECT ANY TABLE
Not applicable
SELECT_CATALOG_ROLE
SELECT
SELECT ANY DICTIONARY
Not applicable
The following user privileges are required for Oracle applications:
  • AQ_ADMINISTRATOR_ROLE
  • CTXAPP
  • HR_REPORTING_USER
  • OLAP_USER
  • INSERT ANY TABLE (or specific to Oracle application tables where the report/form writes to the table)
  • UPDATE ANY TABLE (or specific to Oracle application tables where the report/form writes to the table)
  • DELETE ANY TABLE (or specific to Oracle application tables where the report/form writes to the table)
Use the following privileges to help improve Data Archive performance:
  • CREATE ANY OUTLINE
  • DROP ANY OUTLINE

0 COMMENTS

We’d like to hear from you!