8-01.sql

本光盘是《JSP应用教程》的配套光盘

spool C:\DBCreateInfo.log;
-- 创建表空间
CREATE TABLESPACE SRM30
DATAFILE 'SRM.dat' SIZE 5M 
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED;
-- 创建用户
CREATE USER SRMUser
  IDENTIFIED BY SRMUser
DEFAULT  TABLESPACE SRM30;
ALTER USER SRMUser DEFAULT ROLE ALL;
GRANT CONNECT TO SRMUser;
GRANT RESOURCE TO SRMUser;
spool out;