====== PSB ======
==== 사용자삭제 ====
<code sql>
DROP USER psbehr CASCADE;
</code>
==== 사용자생성 ====
<code sql>
alter session set "_ORACLE_SCRIPT"=true;

create user psbehr identified by pepper123;
grant create view to psbehr; // OR GRANT CREATE ANY VIEW TO psbehr;

GRANT CONNECT, RESOURCE  TO PSBEHR;
GRANT EXECUTE ON DBMS_OBFUSCATION_TOOLKIT TO PSBEHR;
GRANT EXECUTE ON DBMS_CRYPTO TO PSBEHR;
ALTER USER PSBEHR ACCOUNT UNLOCK ;
SELECT * FROM DBA_ROLE_PRIVS
WHERE GRANTEE = 'PSBEHR' ;
ALTER USER PSBEHR ACCOUNT UNLOCK ;

--Alter User 유저명 default tablespace 테이블스페이스명;
Alter User PSBEHR default tablespace TS_PSBEHR_DAT;
</code>
==== Tablespace 사용권한부여 ====
<code sql>
ALTER USER psbehr QUOTA UNLIMITED ON ts_psbehr_dat;
ALTER USER psbehr QUOTA UNLIMITED ON ts_psbehr_idx;
</code>