-- 다음 SQL문 실행 결과를 복사해서 실행한다. SELECT 'DROP TABLE "' || TABLE_NAME || '" CASCADE CONSTRAINTS;' FROM user_tables;

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 [대상계정]; GR..