[Oracle] GRANT, REVOKE

권한 부여/회수

--권한 부여
GRANT ALL ON TB_TEMP TO SCOTT;
GRANT SELECT ON TB_TEMP TO SCOTT;
GRANT SELECT, INSERT, UPDATE, DELETE ON TB_TEMP TO SCOTT;

--권한 회수
REVOKE ALL ON TB_TEMP FROM  SCOTT;
REVOKE SELECT ON TB_TEMP FROM SCOTT;
REVOKE SELECT, INSERT, UPDATE, DELETE ON TB_TEMP FROM SCOTT;

 

EXECUTE 권한 부여/회수

-- 실행 권한 부여
GRANT EXECUTE ON 펑션명|프로시저명|패키지명 TO 유저;

-- 실행 권한 회수
REVOKE EXECUTE ON 펑션명|프로시저명|패키지명 FROM 유저;