1.安装数据库时建立一个全局的数据库,即服务标识。同时建有相应的sysdba用户和密码。
2.用sysdba用户登录全局数据库,建立表空间,建用户/密码 并将所建的空间赋于该用户。
3.赋与该用户建表,删表等一些权限。
4.用该用户进行登录,建表等操作。
至此,数据库的空间,用户已建好。
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;