• Home
• au.net.causal.maven.plugins
• boxdb-maven-plugin
• 3.1
• source code
• oracle-create-database.sql

×

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.

au.net.causal.maven.plugins.boxdb.db.oracle-create-database.sql Maven / Gradle / Ivy

whenever sqlerror exit 1;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ALTER USER SYSTEM ACCOUNT UNLOCK;
ALTER USER SYSTEM IDENTIFIED BY oracle;
CREATE USER ${box.databaseUser} IDENTIFIED BY ${box.databasePassword} DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;
GRANT CONNECT TO ${box.databaseUser};
GRANT CREATE TABLE TO ${box.databaseUser};
GRANT CREATE SYNONYM TO ${box.databaseUser};
GRANT CREATE TYPE TO ${box.databaseUser};
GRANT CREATE VIEW TO ${box.databaseUser};
GRANT CREATE SEQUENCE TO ${box.databaseUser};
GRANT CREATE TRIGGER TO ${box.databaseUser};
ALTER USER ${box.databaseUser} ACCOUNT UNLOCK;
ALTER USER ${box.databaseUser} IDENTIFIED BY ${box.databasePassword};
EXIT;