DATABASE
오라클 테이블 권한 부여
Rainbound-IT
2022. 9. 21. 09:37
반응형
권한부여방법
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
반응형