[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;