오라클공부 608. 테이블 생성 실무사례

테이블 생성 실무사례

 

GRANT DELETE ON ADM.TORDER TO CHNNL;
GRANT INSERT ON ADM.TORDER TO CHNNL;
GRANT SELECT ON ADM.TORDER TO CHNNL WITH GRANT OPTION;
GRANT UPDATE ON ADM.TORDER TO CHNNL;
중략
GRANT DELETE ON ADM.TORDER TO DML_ROLE;
GRANT INSERT ON ADM.TORDER TO DML_ROLE;
GRANT SELECT ON ADM.TORDER TO DML_ROLE;
GRANT UPDATE ON ADM.TORDER TO DML_ROLE;
GRANT SELECT ON ADM.TORDER TO SELECT_ROLE;

COMMENT ON TABLE ADM.TORDER IS '주문마스터' ;
COMMENT ON COLUMN ADM.TORDER.CONTACT_NO IS '접촉번호' ;
중략