|
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;
|