8-01.sql

来自「石志国著《JSP应用教程》」· SQL 代码 · 共 14 行

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;