Preface
Installation Overview
- Introduction
- Data Archive Installation
- Data Vault Installation
- Component Selection
- Application Accelerator Installation
- Dynamic Data Masking Installation
  - Enabling Dynamic Data Masking
Before You Install
- License Key
- X Window Server
- Data Archive Requirements for the ILM Repository
  - ILM Repository User
- Data Archive Requirements for the ILM Engine
- Data Vault Requirements
Data Archive Installation
- Data Archive Installation Overview
  - Installation Package
- Installing Data Archive Components
- Graphical Mode Installation
- Console Mode Installation
- Silent Mode Installation
  - Silent Mode Installation Properties
  - Installing in Silent Mode
Data Vault Installation
- Data Vault Installation Overview
- Graphical Mode Installation
- Console Mode Installation
- Silent Mode Installation
  - Step 1. Create the Properties File
  - Step 2. Run the Silent Installer
Application Accelerator Installation
- Application Accelerator Installation Overview
- Installing the Application Accelerators in Graphical Mode
- Installing the Application Accelerators in Console Mode
Application Retirement for Healthcare Accelerator Installation
- Application Retirement for Healthcare Accelerator Installation Overview
- Prerequisites
- Installing the Accelerator in Graphical Mode
- Installing the Accelerator in Console Mode
- After You Install
MongoDB Accelerator Installation
- MongoDB Accelerator Installation Overview
- Installing the MongoDB Accelerator in Graphical Mode
- Installing the MongoDB Accelerator in Console Mode
- After You Install
Salesforce Accelerator Installation
- Salesforce Accelerator Installation Overview
- Installing the Accelerator in Graphical Mode
- Installing the Accelerator in Console Mode
- After You Install
After You Install
- Client Machine Requirements
- Starting the ILM Application Server
  - Logging In to Data Archive
- Starting the Data Vault Components
- Configuring Memory Settings on a 64-bit Computer
- Configuring Embedded Tomcat for HTTPS
- Registering Services as Windows Services
  - Registering the Archive Service
  - Registering the Data Vault Service for External Attachments
- Configuring Data Archive
- Setting up SAP Retirement
Data Archive Upgrade
- Data Archive Upgrade Overview
- Before You Upgrade
- Upgrading Data Archive in Graphical Mode
- Upgrading Data Archive in Console Mode
- Upgrading Data Archive in Silent Mode
- After You Upgrade Data Archive
- Reverting to a Previous Version
Data Vault Upgrade
- Data Vault Upgrade Overview
- Before You Upgrade a Data Vault Component
- Upgrading in Graphical Mode
- Upgrading in Console Mode
- Upgrading in Silent Mode
  - Step 1. Create the Properties File
  - Step 2. Run the Silent Installer
- Troubleshooting Data Vault Upgrade
- After You Upgrade
- Reverting an Upgrade
ILM Data Validation Option Setup
- ILM Data Validation Option Setup Overview
- Before You Set Up the ILM Data Validation Option
- Install the Data Vault Service ODBC Driver
  - Installing the Data Vault ODBC Driver in Graphical Mode
  - Installing the Data Vault ODBC Driver in Console Mode
- Create a Data Vault Service ODBC Data Source
  - Creating an ODBC Data Source on Windows
    - Using the Windows ODBC Data Source Administrator to Create a Data Source
    - Data Vault ODBC Data Source Parameters
  - Creating an ODBC Data Source on UNIX
- Create a PowerCenter Connection Object
- After You Set Up the ILM Data Validation Option
Data Archive Source and Target Database Requirements
- Source Database Requirements
- Target Database Requirements
Data Archive Connectivity
- Data Archive Connectivity Overview
- Native Connectivity
- DataDirect Connect JDBC Connectivity
- PowerExchange Connectivity
- Third-Party JDBC Connectivity
Data Archive Uninstallation
- Data Archive Uninstallation Overview
- Restore Archived Data
- Dropping Database Users and Links
- Dropping the ILM Repository
- Deleting the ILM Application Server Directory
- Uninstalling the Data Vault
- Uninstalling Source Adapters
- Deleting Remaining ILM Files
SAP Application Retirement
- SAP Application Retirement Overview
- SAP Application Retirement Architecture Options
- Setting Up SAP Application Retirement
- Step 1. Install the SAP Java Connector
- Step 2. Apply the SAP Transports
- Step 3. Assign Roles
- Step 4. Configure Conf.Properties
- Step 5: Set up the FTP or NFS Connection
  - Creating the FTP Connection
  - Creating the NFS Mount
Appendix A: Database Users and Privileges
- Database Users and Privileges Overview
- Administration User
- Production Application User
- Staging User
- History Read-Only User
- History Application User
- Combined User and Archive User for Seamless Access
- IBM DB2 Privileges
  - Bind Packages Privileges
  - Login User Privileges
- SAP Application Retirement Privileges
  - ZINFA_RETIREMENT_PREPARATION Role
Appendix B: Data Visualization Designer Installation
- Data Visualization Designer System Requirements
- Installing Data Visualization Designer
Appendix C: Data Archive Installation Requirements Checklist and Architecture Options
- Pre-Installation Requirements Overview
- Archive to a Database Checklists
- Archive or Retire to Data Vault Checklists
- Data Archive Options Installation Checklist
  - SAP Retirement Installation Checklist
- Data Archive Architecture Recommendations

Installation and Upgrade Guide

6.5.1
- 6.5 HotFix 1
- 6.5

Back Next

Administration User

The administration database user has DBA rights to the database, including the ability to run DDL and access system-level objects.

The administration user typically resides on both the source and target databases. During the archive process, the administration user queries the catalog tables. You can use the administration user to create and drop the public database link if the database link to the repository does not exist.

The administration user requires the following user privileges for the installation:

Oracle Privileges	Microsoft SQL Server Privileges	IBM Db2 Privileges
ALTER SESSION	ALTER EVENT SESSION	ALTER SESSION
ALTER USER	ALTER USER
CREATE SESSION	CREATE EVENT SESSION	CREATE EVENT SESSION
CREATE USER	CREATE USER
CREATE TABLESPACE	Not applicable
GRANT CONNECT	GRANT CONNECT/CREATE USER
SELECT_CATALOG_ROLE	SELECT
Grant any privilege TO `user_name` with admin option.	Grant any privilege TO `user_name` with admin option.	Grant any privilege TO `user_name` with admin option.

The administration user typically requires the following user privileges for archive processes:

SELECT DBA_SEGMENTS. Required for the generate candidates row count report.

SELECT ANY TABLE. Not required if the administration user has access to application user tables.

CREATE PUBLIC DATABASE LINK. Not required if the archive connection definition includes the database link name.

DROP PUBLIC DATABASE LINK. Not required if the archive connection definition includes the database link name.

The administration user requires select privileges on the following views in order for the DGA Data Collection job to run successfully:

DBA_DATA_FILES

DBA_FREE_SPACE

DBA_INDEXES

DBA_SEGMENTS

DBA_TABLES

DBA_TABLESPACES

Microsoft SQL Server Requirements

On Microsoft SQL Server, the Administration user must have the serveradmin role.

Rename Saved Search

Table of Contents

Installation and Upgrade Guide

Installation and Upgrade Guide

Administration User

Administration User

Microsoft SQL Server Requirements