数据库表空间与相应的用户

// 先建好数据库，略。。。。。。。

//建表空间 

CREATE TABLESPACE "${tablespace}" DATAFILE  '${tablespace}.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;
//建用户

CREATE USER ${jdbc.userid} IDENTIFIED BY ${jdbc.password} DEFAULT TABLESPACE "${tablespace}";

//赋权限给用户
    GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE PUBLIC SYNONYM TO ${jdbc.userid} WITH ADMIN OPTION;

    GRANT ALTER ANY ROLE, ALTER ANY SEQUENCE,
    ALTER ANY TABLE, ALTER TABLESPACE, ALTER ANY TRIGGER,
    COMMENT ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY TABLE,
    CREATE ANY TRIGGER, CREATE ROLE, CREATE TABLESPACE,
    CREATE USER, DROP ANY SEQUENCE, DROP ANY TABLE,
    DROP ANY TRIGGER, DROP TABLESPACE, DROP USER,
    DROP ANY ROLE, GRANT ANY ROLE, INSERT ANY TABLE,
    SELECT ANY TABLE, UPDATE ANY TABLE
    TO ${jdbc.userid} WITH ADMIN OPTION;