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;