create_role.sql 스크립트
작성자 관리자 작성시간 2006-03-28 23:36:53
 

connect system/manager
GRANT DBA TO YONG;

CONNECT yong/gari
CREATE ROLE Query_Data;
CREATE ROLE Update_Data;
CREATE ROLE Delete_Data;

GRANT CONNECT                  TO Query_Data;

GRANT SELECT, INSERT ON Account  TO Query_Data;

GRANT UPDATE ON Account  TO Update_Data;

GRANT DELETE ON Account  TO Delete_Data;

CREATE USER SeryPark IDENTIFIED By SeriPark;

GRANT Query_Data TO SeryPark;


목록 | 입력 | 수정 | 답변 | 삭제