Create new user for own schema

connect <main-username>/<main-password>@<database> as sysdba;

-- USER SQL
CREATE USER <username> IDENTIFIED BY <password>
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";

-- QUOTAS

-- ROLES
GRANT "DV_MONITOR" TO <username>;
GRANT "SHARDED_SCHEMA_OWNER" TO <username>;
GRANT "WM_ADMIN_ROLE" TO <username>;
GRANT "OLAP_USER" TO <username>;
GRANT "DV_SECANALYST" TO <username>;
GRANT "MAINTPLAN_APP" TO <username>;
GRANT "RECOVERY_CATALOG_OWNER_VPD" TO <username>;
GRANT "AVTUNE_PKG_ROLE" TO <username>;
GRANT "GDS_CATALOG_SELECT" TO <username>;
GRANT "PGX_SESSION_GET_PUBLISHED_GRAPH" TO <username>;
GRANT "SCHEDULER_ADMIN" TO <username>;
GRANT "PROVISIONER" TO <username>;
GRANT "PGX_SERVER_GET_INFO" TO <username>;
GRANT "APPLICATION_TRACE_VIEWER" TO <username>;
GRANT "LBAC_DBA" TO <username>;
GRANT "OSAK_ADMIN_ROLE" TO <username>;
GRANT "DV_DATAPUMP_NETWORK_LINK" TO <username>;
GRANT "GSMUSER_ROLE" TO <username>;
GRANT "GATHER_SYSTEM_STATISTICS" TO <username>;
GRANT "LOGSTDBY_ADMINISTRATOR" TO <username>;
GRANT "DBJAVASCRIPT" TO <username>;
GRANT "GSM_POOLADMIN_ROLE" TO <username>;
GRANT "HS_ADMIN_ROLE" TO <username>;
GRANT "OGG_APPLY" TO <username>;
GRANT "XS_SESSION_ADMIN" TO <username>;
GRANT "GSMCATUSER_ROLE" TO <username>;
GRANT "JAVADEBUGPRIV" TO <username>;
GRANT "CONNECT" TO <username>;
GRANT "SQL_FIREWALL_ADMIN" TO <username>;
GRANT "ACCHK_READ" TO <username>;
GRANT "PGX_SESSION_READ_MODEL" TO <username>;
GRANT "SQL_FIREWALL_VIEWER" TO <username>;
GRANT "SODA_APP" TO <username>;
GRANT "BDSQL_ADMIN" TO <username>;
GRANT "PGX_SESSION_NEW_GRAPH" TO <username>;
GRANT "GSMADMIN_ROLE" TO <username>;
GRANT "GRAPH_DEVELOPER" TO <username> ;
GRANT "JAVAUSERPRIV" TO <username>;
GRANT "XDB_SET_INVOKER" TO <username>;
GRANT "JAVA_ADMIN" TO <username>;
GRANT "DBFS_ROLE" TO <username>;
GRANT "PDB_DBA" TO <username>;
GRANT "RDFCTX_ADMIN" TO <username>;
GRANT "CDB_DBA" TO <username>;
GRANT "JAVASYSPRIV" TO <username>;
GRANT "GSMROOTUSER_ROLE" TO <username>;
GRANT "HS_ADMIN_SELECT_ROLE" TO <username>;
GRANT "AUDIT_VIEWER" TO <username>;
GRANT "RESOURCE" TO <username>;
GRANT "DV_OWNER" TO <username>;
GRANT "OGG_CAPTURE" TO <username>;
GRANT "EXP_FULL_DATABASE" TO <username>;
GRANT "OGG_APPLY_PROCREP" TO <username>;
GRANT "PGX_SESSION_ADD_PUBLISHED_GRAPH" TO <username>;
GRANT "CAPTURE_ADMIN" TO <username>;
GRANT "OEM_ADVISOR" TO <username>;
GRANT "OGG_SHARED_CAPTURE" TO <username>;
GRANT "DBA" TO <username>;
GRANT "PPLB_ROLE" TO <username>;
GRANT "CTXAPP" TO <username>;
GRANT "DV_AUDIT_CLEANUP" TO <username>;
GRANT "OLAP_XS_ADMIN" TO <username>;
GRANT "XS_CACHE_ADMIN" TO <username>;
GRANT "GRAPH_USER" TO <username> ;
GRANT "DB_DEVELOPER_ROLE" TO <username>;
GRANT "AUDIT_ADMIN" TO <username>;
GRANT "XDB_WEBSERVICES_OVER_HTTP" TO <username>;
GRANT "AQ_ADMINISTRATOR_ROLE" TO <username>;
GRANT "SYSUMF_ROLE" TO <username>;
GRANT "XDB_WEBSERVICES" TO <username>;
GRANT "OPTIMIZER_PROCESSING_RATE" TO <username>;
GRANT "RECOVERY_CATALOG_USER" TO <username>;
GRANT "DV_ADMIN" TO <username>;
GRANT "DV_POLICY_OWNER" TO <username>;
GRANT "DV_GOLDENGATE_ADMIN" TO <username>;
GRANT "IMP_FULL_DATABASE" TO <username>;
GRANT "DV_XSTREAM_ADMIN" TO <username>;
GRANT "DV_PATCH_ADMIN" TO <username>;
GRANT "GGSYS_ROLE" TO <username>;
GRANT "NOTIFICATIONS_USER" TO <username>;
GRANT "XSTREAM_APPLY" TO <username> ;
GRANT "DATAPUMP_EXP_FULL_DATABASE" TO <username>;
GRANT "EJBCLIENT" TO <username>;
GRANT "HS_ADMIN_EXECUTE_ROLE" TO <username>;
GRANT "JMXSERVER" TO <username>;
GRANT "OLAP_DBA" TO <username>;
GRANT "ADM_PARALLEL_EXECUTE_TASK" TO <username>;
GRANT "JAVAIDPRIV" TO <username>;
GRANT "SELECT_CATALOG_ROLE" TO <username>;
GRANT "DGPDB_ROLE" TO <username>;
GRANT "PGX_SESSION_MODIFY_MODEL" TO <username>;
GRANT "DATAPUMP_IMP_FULL_DATABASE" TO <username>;
GRANT "OEM_MONITOR" TO <username>;
GRANT "PGX_SERVER_MANAGE" TO <username>;
GRANT "GRAPH_ADMINISTRATOR" TO <username>;
GRANT "AQ_USER_ROLE" TO <username>;
GRANT "RECOVERY_CATALOG_OWNER" TO <username> ;
GRANT "DV_GOLDENGATE_REDO_ACCESS" TO <username>;
GRANT "XSTREAM_CAPTURE" TO <username>;
GRANT "SAGA_CONNECT_ROLE" TO <username>;
GRANT "SAGA_PARTICIPANT_ROLE" TO <username>;
GRANT "XDB_WEBSERVICES_WITH_PUBLIC" TO <username>;
GRANT "EXECUTE_CATALOG_ROLE" TO <username>;
GRANT "DV_ACCTMGR" TO <username>;
GRANT "NOTIFICATIONS_ADMIN" TO <username>;
GRANT "SAGA_ADM_ROLE" TO <username>;
GRANT "PGX_SESSION_CREATE" TO <username>;
GRANT "DBMS_MDX_INTERNAL" TO <username>;
GRANT "DV_STREAMS_ADMIN" TO <username>;
GRANT "XS_NAMESPACE_ADMIN" TO <username>;
GRANT "BDSQL_USER" TO <username>;
GRANT "AUTHENTICATEDUSER" TO <username>;
GRANT "XS_CONNECT" TO <username>;
GRANT "XDBADMIN" TO <username>;
GRANT "PGX_SESSION_COMPILE_ALGORITHM" TO <username>;
ALTER USER <username> DEFAULT ROLE "DV_MONITOR","SHARDED_SCHEMA_OWNER","WM_ADMIN_ROLE","OLAP_USER","DV_SECANALYST","MAINTPLAN_APP","RECOVERY_CATALOG_OWNER_VPD","AVTUNE_PKG_ROLE","GDS_CATALOG_SELECT","PGX_SESSION_GET_PUBLISHED_GRAPH","SCHEDULER_ADMIN","PROVISIONER","PGX_SERVER_GET_INFO","APPLICATION_TRACE_VIEWER","LBAC_DBA","OSAK_ADMIN_ROLE","DV_DATAPUMP_NETWORK_LINK","GSMUSER_ROLE","GATHER_SYSTEM_STATISTICS","LOGSTDBY_ADMINISTRATOR","DBJAVASCRIPT","GSM_POOLADMIN_ROLE","HS_ADMIN_ROLE","OGG_APPLY","XS_SESSION_ADMIN","GSMCATUSER_ROLE","JAVADEBUGPRIV","CONNECT","SQL_FIREWALL_ADMIN","ACCHK_READ","PGX_SESSION_READ_MODEL","SQL_FIREWALL_VIEWER","SODA_APP","BDSQL_ADMIN","PGX_SESSION_NEW_GRAPH","GSMADMIN_ROLE","GRAPH_DEVELOPER","JAVAUSERPRIV","XDB_SET_INVOKER","JAVA_ADMIN","DBFS_ROLE","PDB_DBA","RDFCTX_ADMIN","CDB_DBA","JAVASYSPRIV","GSMROOTUSER_ROLE","HS_ADMIN_SELECT_ROLE","AUDIT_VIEWER","RESOURCE","DV_OWNER","OGG_CAPTURE","EXP_FULL_DATABASE","OGG_APPLY_PROCREP","PGX_SESSION_ADD_PUBLISHED_GRAPH","CAPTURE_ADMIN","OEM_ADVISOR","OGG_SHARED_CAPTURE","DBA","PPLB_ROLE","CTXAPP","DV_AUDIT_CLEANUP","OLAP_XS_ADMIN","XS_CACHE_ADMIN","GRAPH_USER","DB_DEVELOPER_ROLE","AUDIT_ADMIN","XDB_WEBSERVICES_OVER_HTTP","AQ_ADMINISTRATOR_ROLE","SYSUMF_ROLE","XDB_WEBSERVICES","OPTIMIZER_PROCESSING_RATE","RECOVERY_CATALOG_USER","DV_ADMIN","DV_POLICY_OWNER","DV_GOLDENGATE_ADMIN","IMP_FULL_DATABASE","DV_XSTREAM_ADMIN","DV_PATCH_ADMIN","GGSYS_ROLE","NOTIFICATIONS_USER","XSTREAM_APPLY","DATAPUMP_EXP_FULL_DATABASE","EJBCLIENT","HS_ADMIN_EXECUTE_ROLE","JMXSERVER","OLAP_DBA","ADM_PARALLEL_EXECUTE_TASK","JAVAIDPRIV","SELECT_CATALOG_ROLE","DGPDB_ROLE","PGX_SESSION_MODIFY_MODEL","DATAPUMP_IMP_FULL_DATABASE","OEM_MONITOR","PGX_SERVER_MANAGE","GRAPH_ADMINISTRATOR","AQ_USER_ROLE","RECOVERY_CATALOG_OWNER","DV_GOLDENGATE_REDO_ACCESS","XSTREAM_CAPTURE","SAGA_CONNECT_ROLE","SAGA_PARTICIPANT_ROLE","XDB_WEBSERVICES_WITH_PUBLIC","EXECUTE_CATALOG_ROLE","DV_ACCTMGR","NOTIFICATIONS_ADMIN","SAGA_ADM_ROLE","PGX_SESSION_CREATE","DBMS_MDX_INTERNAL","DV_STREAMS_ADMIN","XS_NAMESPACE_ADMIN","BDSQL_USER","AUTHENTICATEDUSER","XS_CONNECT","XDBADMIN","PGX_SESSION_COMPILE_ALGORITHM";