오라클 권한부여/권한취소

권한부여------------------

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] ;




출처 :http://hello-nanam.tistory.com/1