DB/ORACLE

DB 테이블 권한 부여

Kang_hobin 2022. 7. 5. 14:55
GRANT SELECT, INSERT, DELETE, UPDATE ON TABLE명 TO PUBLIC; -- PUBLIC은 전체
GRANT SELECT, INSERT, DELETE, UPDATE ON TABLE명 TO PUBLIC;

GRANT SELECT ANY TABLE TO PUBLIC; -- ANY TABLE은 전체 테이블

SELECT 'GRANT SELECT ON ' || TNAME || ' TO PUBLIC;' 
  FROM TAB
 WHERE TNAME LIKE '%';