사용자 권한

--① 
CREATE USER PREV_HW -- 생성
IDENTIFIED BY ORCL; -- 비번

--② 
GRANT CREATE SESSION TO PREV_HW; -- 권한 부여

 

 

 

 

 

 

 

 

 

GRANT SELECT ON EMP TO PREV_HW; 

GRANT SELECT ON DEPT TO PREV_HW; 

GRANT SELECT ON SALGRADE TO PREV_HW;

 

 

 

 

 

 

 

 

REVOKE SELECT ON SALGRADE FROM PREV_HW;