GaramX

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;

ALTER USER psbehr QUOTA UNLIMITED ON ts_psbehr_dat;
ALTER USER psbehr QUOTA UNLIMITED ON ts_psbehr_idx;