org.kuali.db.oracle.create.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of jdbc-support Show documentation

Various utility methods for JDBC

There is a newer version: 1.1.3

-- Create a user, give them a password and set a quota for the default tablespace
CREATE USER ${database} 
IDENTIFIED BY ${databasePassword} 
DEFAULT TABLESPACE ${oracle.tablespace.default} 
TEMPORARY TABLESPACE ${oracle.tablespace.temporary} 
QUOTA ${oracle.tablespace.default.quota} ON ${oracle.tablespace.default}
/

-- Grant permissions as needed
GRANT CREATE PROCEDURE
  , CREATE SEQUENCE
  , CREATE SESSION
  , CREATE SYNONYM
  , CREATE TABLE
  , CREATE TRIGGER
  , CREATE TYPE
  , CREATE VIEW 
TO ${database}
/