• Home
• org.bitbucket.bradleysmithllc.etlunit
• etlunit-oracle-database
• 2.0.29
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

.bradleysmithllc.etlunit.etlunit-oracle-database.2.0.29.source-code.oracle_create_schema.vm Maven / Gradle / Ivy

#if( !$tablespaceSpecified )
-- Create custom tablespace
CREATE SMALLFILE TABLESPACE ${tablespace}
DATAFILE '${tablespace}' SIZE 10M REUSE AUTOEXTEND ON NEXT 256K MAXSIZE 32767M
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;;
#else
-- Using system-provided tablespace
#end

#if( !$tempTablespaceSpecified )
-- Temp tablespace w/ Datafile
CREATE SMALLFILE TEMPORARY TABLESPACE ${tempTablespace}
TEMPFILE '${tempTablespace}' SIZE 10M REUSE AUTOEXTEND ON NEXT 256K MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;;
#else
-- Using system-provided temp tablespace
#end

-- User creation and Tablespace assignment
CREATE USER ${databaseName} PROFILE DEFAULT IDENTIFIED BY ${databasePassword}
DEFAULT TABLESPACE ${tablespace} TEMPORARY TABLESPACE ${tempTablespace} QUOTA UNLIMITED ON ${tablespace} ACCOUNT UNLOCK;;

GRANT UNLIMITED TABLESPACE TO ${databaseName} WITH ADMIN OPTION;;

-- Role assignment
GRANT CONNECT TO ${databaseName} WITH ADMIN OPTION;;
GRANT RESOURCE TO ${databaseName} WITH ADMIN OPTION;;

-- System privilege assignment
GRANT ALTER ANY INDEX TO "${databaseName}";;
GRANT ALTER ANY MATERIALIZED VIEW TO "${databaseName}";;
GRANT ALTER ANY PROCEDURE TO "${databaseName}";;
GRANT ALTER ANY SEQUENCE TO "${databaseName}";;
GRANT ALTER ANY TABLE TO "${databaseName}";;
GRANT ALTER ANY TRIGGER TO "${databaseName}";;
GRANT ALTER DATABASE TO "${databaseName}";;
GRANT ALTER PROFILE TO "${databaseName}";;
GRANT ALTER SESSION TO "${databaseName}";;
GRANT ALTER TABLESPACE TO "${databaseName}";;
GRANT ALTER USER TO "${databaseName}";;
GRANT CREATE ANY INDEX TO "${databaseName}";;
GRANT CREATE ANY MATERIALIZED VIEW TO "${databaseName}";;
GRANT CREATE ANY PROCEDURE TO "${databaseName}";;
GRANT CREATE ANY SEQUENCE TO "${databaseName}";;
GRANT CREATE ANY SYNONYM TO "${databaseName}";;
GRANT CREATE ANY TABLE TO "${databaseName}";;
GRANT CREATE ANY TRIGGER TO "${databaseName}";;
GRANT CREATE ANY VIEW TO "${databaseName}";;
GRANT CREATE MATERIALIZED VIEW TO "${databaseName}";;
GRANT CREATE TABLE TO "${databaseName}";;
GRANT CREATE TABLESPACE TO "${databaseName}";;
GRANT CREATE VIEW TO "${databaseName}";;
GRANT DROP ANY INDEX TO "${databaseName}";;
GRANT DROP ANY MATERIALIZED VIEW TO "${databaseName}";;
GRANT DROP ANY PROCEDURE TO "${databaseName}";;
GRANT DROP ANY SEQUENCE TO "${databaseName}";;
GRANT DROP ANY SYNONYM TO "${databaseName}";;
GRANT DROP ANY TABLE TO "${databaseName}";;
GRANT DROP ANY TRIGGER TO "${databaseName}";;
GRANT DROP ANY VIEW TO "${databaseName}";;
GRANT DROP PUBLIC SYNONYM TO "${databaseName}";;
GRANT DROP TABLESPACE TO "${databaseName}";;
GRANT DROP USER TO "${databaseName}";;
GRANT EXECUTE ANY PROCEDURE TO "${databaseName}";;
GRANT SELECT ANY SEQUENCE TO "${databaseName}";;