The ILM repository user creates and owns the database objects in the ILM repository schema. The database objects contain repository data such as application metadata, users, jobs, and workbench definitions. The ILM repository user is also called the AMHOME user.

Data Archive requires the ILM repository user. You can create the user before the installation, or the installation can create the user and grant the required privileges.

For example, you can run the following script to create the ILM repository user:

The following table lists the privileges required for the ILM repository:

Oracle Privileges	Microsoft SQL Server Privileges	IBM DB2 Privileges
ALTER SESSION	ALTER EVENT SESSION	ALTER SESSION
CONNECT	For information about creating connections to the SQL Server database, see http://msdn.microsoft.com/en-us/library/s4yys16a(v=vs.90).aspx	CONNECT
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 TYPE	CREATE TYPE	CREATE TYPE
CREATE VIEW	CREATE VIEW	CREATE VIEW
DEFAULT ROLE ALL	Default roles enabled when user logs in.	Not applicable