[ORACLE] create user


drop user 帳號 cascade;--可忽略 但建議使用

CREATE USER 帳號 IDENTIFIED BY 密碼
  DEFAULT TABLESPACE TABLESPACE名稱通常為USERS TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT ACCOUNT UNLOCK;

GRANT CONNECT TO 帳號;
GRANT RESOURCE TO 帳號;
GRANT CREATE SESSION TO 帳號;