오라클 테이블 권한 부여

권한부여방법

 

GRANT SELECT ON [TABLE NAME] TO [USER];
GRANT INSERT ON [TABLE NAME] TO [USER];
GRANT DELETE ON [TABLE NAME] TO [USER];
GRANT UPDATE ON [TABLE NAME] TO [USER];

-- 또는
GRANT SELECT, INSERT, DELETE, UPDATE ON [TABLE NAME] TO [USER] ;

 

 

 

권한부여취소

 

REVOKE SELECT ON [TABLE NAME] FROM [USER];
REVOKE INSERT ON [TABLE NAME] FROM [USER];
REVOKE DELETE ON [TABLE NAME] FROM [USER];
REVOKE UPDATE ON [TABLE NAME] FROM [USER];

-- 또는
REVOKE SELECT, INSERT, DELETE, UPDATE ON [TABLE NAME] FROM [USER] ;

 

출처:

https://hello-nanam.tistory.com/1

오라클 테이블 권한 부여 ( GRANT )