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;


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦