테이블에 DML 권한부여
방법 1
GRANT SELECT ON [TABLE] TO [USER_ID];
GRANT INSERT ON [TABLE] TO [USER_ID];
GRANT DELETE ON [TABLE] TO [USER_ID];
GRANT UPDATE ON [TABLE TO [USER_ID];
방법 2
GRANT SELECT,INSERT,DELETE,UPDATE ON [TABLE] TO [USER_ID];
CREATE OR REPLACE SYNONYM [USER_ID].[TABLE] FOR [MASTER_ID].[TABLE]
테이블에 DML 권한 회수
방법 1
REVOKE SELECT ON [TABLE] FROM [USER_ID];
REVOKE INSERT ON [TABLE] FROM [USER_ID];
REVOKE DELETE ON [TABLE] FROM [USER_ID];
REVOKE UPDATE ON [TABLE] FROM [USER_ID];
방법 2
REVOKE SELECT,INSERT,DELETE,UPDATE ON [TABLE] FROM [USER_ID];
