------- CREATE DB passdb
CREATE SMALLFILE TABLESPACE "x3dpassadmin" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/passdb.dbf' SIZE 10M AUTOEXTEND
ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
create user x3dpassadmin identified by "1qaz2wsx";
grant CREATE SEQUENCE to x3dpassadmin;
grant CREATE SESSION to x3dpassadmin;
grant CREATE SYNONYM to x3dpassadmin;
grant CREATE TABLE to x3dpassadmin;
ALTER USER x3dpassadmin default tablespace "x3dpassadmin";
ALTER USER x3dpassadmin QUOTA UNLIMITED ON "x3dpassadmin";

------- CREATE DB passtkdb
CREATE SMALLFILE TABLESPACE "x3dpasstokens" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/passtkdb.dbf' SIZE 10M AUTOEXTEND 
ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
create user x3dpasstokens identified by "1qaz2wsx";
grant CREATE SEQUENCE to x3dpasstokens;
grant CREATE SESSION to x3dpasstokens;
grant CREATE SYNONYM to x3dpasstokens;
grant CREATE TABLE to x3dpasstokens;
ALTER USER x3dpasstokens default tablespace "x3dpasstokens";
ALTER USER x3dpasstokens QUOTA UNLIMITED ON "x3dpasstokens";

CREATE USER x3ddashadmin IDENTIFIED BY "1qaz2wsx";
GRANT CREATE SESSION TO x3ddashadmin;
GRANT RESOURCE TO x3ddashadmin;
CREATE SMALLFILE TABLESPACE x3ddashadmin LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/x3ddashadmin.dbf' SIZE 10M 
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER USER x3ddashadmin default tablespace x3ddashadmin;
ALTER USER x3ddashadmin QUOTA UNLIMITED ON x3ddashadmin;
GRANT UNLIMITED TABLESPACE TO x3ddashadmin;

create user M1 identified by "1qaz2wsx"; 
grant connect, resource, create view to M1; 
CREATE SMALLFILE TABLESPACE "M1" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/M1.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ; 
ALTER USER M1 default tablespace M1;
GRANT UNLIMITED TABLESPACE TO M1;
CREATE SMALLFILE TABLESPACE "I1_DATA" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/I1_DATA.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ; 
CREATE SMALLFILE TABLESPACE "I1_INDEX" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/I1_INDEX.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ; 
CREATE SMALLFILE TABLESPACE "M1_DATA" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/M1_DATA.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ; 
CREATE SMALLFILE TABLESPACE "M1_INDEX" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/M1_INDEX.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE SMALLFILE TABLESPACE "V1_DATA" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/V1_DATA.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ; 
CREATE SMALLFILE TABLESPACE "V1_INDEX" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/V1_INDEX.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

------- CREATE DB DBSOCIAL
--drop user x3dswym cascade
create user x3dswym identified by "1qaz2wsx";
grant CREATE SEQUENCE to x3dswym;
grant CREATE SESSION to x3dswym;
grant CREATE TABLE to x3dswym;
grant CREATE VIEW to x3dswym;
grant CREATE PROCEDURE to x3dswym;
grant CREATE TRIGGER to x3dswym;
CREATE SMALLFILE TABLESPACE "x3dswym" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/DBSOCIAL.dbf' 
SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER USER x3dswym default tablespace "x3dswym";
ALTER USER x3dswym QUOTA UNLIMITED ON "x3dswym";
GRANT UNLIMITED TABLESPACE TO x3dswym;

------- CREATE DB DBMEDIA
--drop user x3dswym_media cascade
create user x3dswym_media identified by "1qaz2wsx";
grant CREATE SEQUENCE to x3dswym_media;
grant CREATE SESSION to x3dswym_media;
grant CREATE TABLE to x3dswym_media;
grant CREATE VIEW to x3dswym_media;
grant CREATE PROCEDURE to x3dswym_media;
grant CREATE TRIGGER to x3dswym_media;
CREATE SMALLFILE TABLESPACE "x3dswym_media" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/DBMEDIA.dbf' 
SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER USER x3dswym_media default tablespace "x3dswym_media";
ALTER USER x3dswym_media QUOTA UNLIMITED ON "x3dswym_media";
GRANT UNLIMITED TABLESPACE TO x3dswym_media;

-------- CREATE DB DBWIDGET
--drop user x3dswym_widget cascade
create user x3dswym_widget identified by "1qaz2wsx";
grant CREATE SEQUENCE to x3dswym_widget;
grant CREATE SESSION to x3dswym_widget;
grant CREATE TABLE to x3dswym_widget;
grant CREATE VIEW to x3dswym_widget;
grant CREATE PROCEDURE to x3dswym_widget;
grant CREATE TRIGGER to x3dswym_widget;
CREATE SMALLFILE TABLESPACE "x3dswym_widget" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/DBWIDGET.dbf'
SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER USER x3dswym_widget default tablespace "x3dswym_widget";
ALTER USER x3dswym_widget QUOTA UNLIMITED ON "x3dswym_widget";
GRANT UNLIMITED TABLESPACE TO x3dswym_widget;

create user x3dcomment identified by "1qaz2wsx";
grant CREATE SEQUENCE to x3dcomment;
grant CREATE SESSION to x3dcomment;
grant CREATE TABLE to x3dcomment;
grant CREATE VIEW to x3dcomment;
grant CREATE PROCEDURE to x3dcomment;
grant CREATE TRIGGER to x3dcomment;
CREATE SMALLFILE TABLESPACE "x3dcomment" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/x3dcomment.dbf'
SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER USER x3dcomment default tablespace "x3dcomment";
ALTER USER x3dcomment QUOTA UNLIMITED ON "x3dcomment";
GRANT UNLIMITED TABLESPACE TO x3dcomment;

create user x3dnotif identified by "1qaz2wsx";
grant CREATE SEQUENCE to x3dnotif;
grant CREATE SESSION to x3dnotif;
grant CREATE TABLE to x3dnotif;
grant CREATE VIEW to x3dnotif;
grant CREATE PROCEDURE to x3dnotif;
grant CREATE TRIGGER to x3dnotif;
CREATE SMALLFILE TABLESPACE "x3dnotif" LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/x3dnotification01.dbf'
SIZE 50M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER USER x3dnotif default tablespace "x3dnotif";
ALTER USER x3dnotif QUOTA UNLIMITED ON "x3dnotif";
GRANT UNLIMITED TABLESPACE TO x3dnotif;