CREATE USER AMARCHIVE
  IDENTIFIED BY password
  DEFAULT TABLESPACE ARC53_STAGE_D
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  
  GRANT SELECT_CATALOG_ROLE TO AMARCHIVE;
  GRANT CTXAPP TO AMARCHIVE;
  GRANT HR_REPORTING_USER TO AMARCHIVE WITH ADMIN OPTION;
  GRANT CONNECT TO AMARCHIVE;
  GRANT AQ_ADMINISTRATOR_ROLE TO AMARCHIVE WITH ADMIN OPTION;
  GRANT HR_SECURE_USER TO AMARCHIVE WITH ADMIN OPTION;
  GRANT OLAP_USER TO AMARCHIVE;
  ALTER USER AMARCHIVE DEFAULT ROLE ALL; 
  GRANT CREATE ANY TRIGGER TO AMARCHIVE;
  GRANT DROP ANY PROCEDURE TO AMARCHIVE;
  GRANT CREATE DATABASE LINK TO AMARCHIVE;
  GRANT CREATE ANY SEQUENCE TO AMARCHIVE;
  GRANT DROP ANY VIEW TO AMARCHIVE;
  GRANT UPDATE ANY TABLE TO AMARCHIVE;
  GRANT ALTER ANY TABLE TO AMARCHIVE;
  GRANT CREATE TABLE TO AMARCHIVE;
  GRANT CREATE ANY CONTEXT TO AMARCHIVE;
  GRANT CREATE ANY DIRECTORY TO AMARCHIVE;
  GRANT CREATE TRIGGER TO AMARCHIVE;
  GRANT GRANT ANY ROLE TO AMARCHIVE;
  GRANT SELECT ANY SEQUENCE TO AMARCHIVE;
  GRANT CREATE ANY TABLE TO AMARCHIVE;
  GRANT DROP ANY MATERIALIZED VIEW TO AMARCHIVE;
  GRANT ALTER ANY MATERIALIZED VIEW TO AMARCHIVE;
  GRANT ALTER ANY TRIGGER TO AMARCHIVE;
  GRANT ALTER ANY ROLE TO AMARCHIVE;
  GRANT ALTER ANY CLUSTER TO AMARCHIVE;
  GRANT ALTER ANY OUTLINE TO AMARCHIVE;
  GRANT DROP PUBLIC SYNONYM TO AMARCHIVE;
  GRANT CREATE CLUSTER TO AMARCHIVE;
  GRANT SELECT ANY TABLE TO AMARCHIVE;
  GRANT DROP ANY TABLE TO AMARCHIVE;
  GRANT SELECT ANY DICTIONARY TO AMARCHIVE;
  GRANT DROP ANY OUTLINE TO AMARCHIVE;
  GRANT CREATE ANY OUTLINE TO AMARCHIVE;
  GRANT DROP ANY CONTEXT TO AMARCHIVE;
  GRANT EXECUTE ANY PROCEDURE TO AMARCHIVE;
  GRANT CREATE PUBLIC DATABASE LINK TO AMARCHIVE;
  GRANT CREATE PUBLIC SYNONYM TO AMARCHIVE;
  GRANT DROP ANY INDEX TO AMARCHIVE;
  GRANT DROP ANY CLUSTER TO AMARCHIVE;
  GRANT COMMENT ANY TABLE TO AMARCHIVE;
  GRANT ALTER SYSTEM TO AMARCHIVE;
  GRANT CREATE TYPE TO AMARCHIVE;
  GRANT DROP ANY TRIGGER TO AMARCHIVE;
  GRANT ALTER ANY PROCEDURE TO AMARCHIVE;
  GRANT DROP ANY ROLE TO AMARCHIVE;
  GRANT ALTER ANY SEQUENCE TO AMARCHIVE;
  GRANT ALTER ANY INDEX TO AMARCHIVE;
  GRANT CREATE ANY CLUSTER TO AMARCHIVE;
  GRANT GLOBAL QUERY REWRITE TO AMARCHIVE;
  GRANT CREATE ANY MATERIALIZED VIEW TO AMARCHIVE;
  GRANT DROP ANY SEQUENCE TO AMARCHIVE;
  GRANT CREATE ROLE TO AMARCHIVE;
  GRANT ADMINISTER DATABASE TRIGGER TO AMARCHIVE;
  GRANT ALTER SESSION TO AMARCHIVE;
  GRANT ANALYZE ANY TO AMARCHIVE;
  GRANT CREATE ANY INDEX TO AMARCHIVE;
  GRANT CREATE ANY PROCEDURE TO AMARCHIVE;
  GRANT CREATE ANY SYNONYM TO AMARCHIVE;
  GRANT CREATE ANY VIEW TO AMARCHIVE;
  GRANT CREATE PROCEDURE TO AMARCHIVE;
  GRANT CREATE SEQUENCE TO AMARCHIVE;
  GRANT CREATE SESSION TO AMARCHIVE;
  GRANT CREATE SYNONYM TO AMARCHIVE;
  GRANT CREATE VIEW TO AMARCHIVE;
  GRANT DELETE ANY TABLE TO AMARCHIVE;
  GRANT DROP ANY SYNONYM TO AMARCHIVE;
  GRANT EXECUTE ANY PROCEDURE TO AMARCHIVE WITH ADMIN OPTION;
  GRANT EXECUTE ANY TYPE TO AMARCHIVE;
  GRANT INSERT ANY TABLE TO AMARCHIVE;
  GRANT LOCK ANY TABLE TO AMARCHIVE;
  GRANT SELECT ANY DICTIONARY TO AMARCHIVE WITH ADMIN OPTION;
  GRANT SELECT ANY TABLE TO AMARCHIVE WITH ADMIN OPTION;
  GRANT UNLIMITED TABLESPACE TO AMARCHIVE;
  GRANT EXECUTE ON APPS.EMCASO_FREIGHT_MGR_PKG TO AMARCHIVE;
  GRANT SELECT ON APPS.EMCASO_QUOTE_HEADERS_ALL_V TO AMARCHIVE;
  GRANT EXECUTE ON APPS.FND_FLEX_SERVER TO AMARCHIVE;
  GRANT EXECUTE ON APPS.WF_EVENT TO AMARCHIVE;
  GRANT EXECUTE ON SYS.DBMS_ALERT TO AMARCHIVE;
  GRANT EXECUTE ON SYS.DBMS_LOCK TO AMARCHIVE;
  GRANT EXECUTE ON SYS.DBMS_SPACE_ADMIN TO AMARCHIVE;
  GRANT SELECT ON SYS.LINK$ TO AMARCHIVE;
  GRANT SELECT ON SYS.USER$ TO AMARCHIVE;
  GRANT EXECUTE_CATALOG_ROLE TO AMARCHIVE;
  GRANT PUBLIC TO AMARCHIVE;
  GRANT RESOURCE TO AMARCHIVE;