사용자 생성

CREATE USER [계정이름]
IDENTIFIED BY [계정비밀번호]
DEFAULT TABLESPACE [테이블스페이스]
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;

GRANT CONNECT, RESOURCE, DBA TO [계정이름];
GRANT CREATE DATABASE LINK TO [대상계정];
GRANT CREATE MATERIALIZED VIEW TO [대상계정];
GRANT CREATE PROCEDURE TO [대상계정];
GRANT CREATE PUBLIC DATABASE LINK TO [대상계정];
GRANT CREATE PUBLIC SYNONYM TO [대상계정];
GRANT CREATE ROLE TO [대상계정];
GRANT CREATE SEQUENCE TO [대상계정];
GRANT CREATE SYNONYM TO [대상계정];
GRANT CREATE TABLE TO [대상계정];
GRANT CREATE TRIGGER TO [대상계정];
GRANT CREATE TYPE TO [대상계정];
GRANT CREATE VIEW TO [대상계정];

ALTER USER [대상계정] DEFAULT ROLE ALL;