CREATE TABLESPACE "QONEYILONG" LOGGING DATAFILE 'G:oracleproduct10.2.0oradataqoneyilongqoneyilong.ora' SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE temporary tablespace "QONEYILONG_TEMP" tempfile 'G:oracleproduct10.2.0oradataqoneyilongqoneyilong_temp.ora' SIZE 100M EXTENT MANAGEMENT LOCAL;

create user root identified by root default tablespace qone temporary tablespace qone_temp;

grant dba to root;

grant connect,resource,create view to root;

GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE PUBLIC SYNONYM TO root WITH ADMIN OPTION;

GRANT ALTER ANY ROLE, ALTER ANY SEQUENCE,ALTER ANY TABLE, ALTER TABLESPACE, ALTER ANY TRIGGER,COMMENT ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY TABLE,CREATE ANY TRIGGER, CREATE ROLE, CREATE TABLESPACE,CREATE USER, DROP ANY SEQUENCE, DROP ANY TABLE,DROP ANY TRIGGER, DROP TABLESPACE, DROP USER,DROP ANY ROLE, GRANT ANY ROLE, INSERT ANY TABLE,SELECT ANY TABLE, UPDATE ANY TABLE TO root;