Use the following scripts as a reference while creating database schema for both Platform Metadata Schema & Application Schema

Platform Metadata Schema:

CREATE USER xxcloudio IDENTIFIED BY "xxcloudio"
 DEFAULT TABLESPACE "USERS"
 TEMPORARY TABLESPACE "TEMP"
 PROFILE DEFAULT
 QUOTA UNLIMITED ON "USERS";

GRANT CREATE JOB TO xxcloudio;
GRANT CREATE MATERIALIZED VIEW TO xxcloudio;
GRANT CREATE PROCEDURE TO xxcloudio;
GRANT CREATE SEQUENCE TO xxcloudio;
GRANT CREATE SESSION TO xxcloudio;
GRANT CREATE SYNONYM TO xxcloudio;
GRANT CREATE TABLE TO xxcloudio;
GRANT CREATE VIEW TO xxcloudio;
GRANT CREATE TRIGGER TO xxcloudio;
GRANT CREATE TYPE TO xxcloudio;

GRANT EXECUTE ON DBMS_LOB TO xxcloudio;
GRANT EXECUTE ON DBMS_SESSION TO xxcloudio;
GRANT EXECUTE ON DBMS_APPLICATION_INFO TO xxcloudio;

GRANT "CONNECT" TO xxcloudio;
GRANT "RESOURCE" TO xxcloudio;
ALTER USER xxcloudio DEFAULT ROLE NONE;
Note: Make sure to change the TABLESPACE names with appropriate values before running these scripts.

Application Schema:

CREATE USER xxapps IDENTIFIED BY "xxapps"
 DEFAULT TABLESPACE "USERS"
 TEMPORARY TABLESPACE "TEMP"
 PROFILE DEFAULT
 QUOTA UNLIMITED ON "USERS";

GRANT CREATE JOB TO xxapps;
GRANT CREATE MATERIALIZED VIEW TO xxapps;
GRANT CREATE PROCEDURE TO xxapps;
GRANT CREATE SEQUENCE TO xxapps;
GRANT CREATE SESSION TO xxapps;
GRANT CREATE SYNONYM TO xxapps;
GRANT CREATE TABLE TO xxapps;
GRANT CREATE VIEW TO xxapps;
GRANT CREATE TRIGGER TO xxapps;
GRANT CREATE TYPE TO xxapps;

GRANT EXECUTE ON DBMS_LOB TO xxapps;
GRANT EXECUTE ON DBMS_SESSION TO xxapps;
GRANT EXECUTE ON DBMS_APPLICATION_INFO TO xxapps;

GRANT "CONNECT" TO xxapps;
GRANT "RESOURCE" TO xxapps;
ALTER USER xxapps DEFAULT ROLE NONE;
Note: If you are installing on Oracle EBS 12.2 or above, make sure to edition enable the XXAPPS schema as shown below

sqlplus "/as sysdba"
alter session set current_schema=APPS;
exec AD_ZD_PREP.ENABLE_CUSTOM_USER('XXAPPS');

Location

101 California Street, Suite 2710
San Francisco, CA 94111


440 N. Wolfe Rd.
Sunnyvale, CA 94085


Office 11, 5th Floor, Building 9,
Mindspace IT Park
Hyderabad 500081

p: +1 (844) AT CloudIO (844-282-5683)
f: +1 (650) 300-5247 | e: sales@cloudio.io
© 2009, 2017 CloudIO Inc. | Terms of Use | Privacy Policy