[Oracle] 表領域の作成とか

前回の続き

表領域の作成

CREATE TABLESPACE TS_USER
  DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TS_USER_01.DBF'
  SIZE 2048M;

CREATE TEMPORARY TABLESPACE TS_USER_TEMP
  TEMPFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TS_USER_TEMP.DBF'
  SIZE 100M
  AUTOEXTEND ON NEXT 5M MAXSIZE 1024M;

ユーザの追加と権限

CREATE USER USER1
  IDENTIFIED BY USER1
  DEFAULT TABLESPACE TS_USER
  TEMPORARY TABLESPACE TS_USER_TEMP
;

権限はとても緩めにしておく。

GRANT CONNECT TO USER1 WITH ADMIN OPTION;
GRANT RESOURCE TO USER1 WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO USER1 WITH ADMIN OPTION;
GRANT DBA TO USER1 WITH ADMIN OPTION;