[oracle] tablespace 생성, user 추가, user권한 부여

1. 테이블스페이스 생성

CREATE TABLESPACE TEST
DATAFILE '/oradata/test.dbf' SIZE 50M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
DEFAULT STORAGE(
INITIAL 20M
NEXT 10M
PCTINCREASE 0
);

 2. 유저생성

CREATE USER testuser01
IDENTIFIED BY test_user_PASSWORD
DEFAULT TABLESPACE TEST
TEMPORARY TABLESPACE TEMP;

 3. 권한부여

 GRANT CONNECT, RESOURCE, DBA TO KARL32;