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