Oracle User Privileges

If your site uses an Oracle database, your DBA must set up a database schema for each repository you plan to create. Each EA user who accesses the repository must supply the name and password of a database user with appropriate access privileges to the schema. The table below shows the required privileges.

Type	Privilege
Roles	GATHER_SYSTEM_STATISTICS (required only for Compute Database Statistics method. See Getting Started in the EA documentation set.)
System Privileges	ALTER SESSION CREATE SESSION CREATE PROCEDURE CREATE SEQUENCE ALTER ANY SEQUENCE CREATE SYNONYM CREATE TRIGGER CREATE ANY TABLE DROP ANY TABLE ALTER ANY INDEX CREATE ANY INDEX DROP ANY INDEX [UNLIMITED TABLESPACE]1
Object Privileges	SELECT on SYS.V_$INSTANCE SELECT on SYS.V_$SESSION SELECT on SYS.V_$PARAMETER