Kevin Yeandel’s Random Access Memory

If you have to have your schema created for you by the hosting company then this is what is required.
Make sure to ask the developers if any triggers will be required as you may wish to add this at the same time.

Schema Parameters        (Tried, tested and in use)
GRANT ALTER SESSION TO xy_resource;
GRANT CREATE DATABASE LINK TO xy_resource;
GRANT CREATE INDEXTYPE TO xy_resource;
GRANT CREATE OPERATOR TO xy_resource;
GRANT CREATE PROCEDURE TO xy_resource;
GRANT CREATE PUBLIC SYNONYM TO xy_resource;
GRANT CREATE ROLE TO xy_resource;
GRANT CREATE SEQUENCE TO xy_resource;
GRANT CREATE SESSION TO xy_resource;
GRANT CREATE SYNONYM TO xy_resource;
GRANT CREATE TABLE TO xy_resource;
GRANT CREATE TYPE TO xy_resource;
GRANT CREATE VIEW TO xy_resource;
GRANT SELECT_CATALOG_ROLE TO xy_resource;