在sqlplus中以sys登陆,把以下语句存到一个.sql文件中,执行一下就可以了CREATE USER SYSTEM IDENTIFIED BY manager DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE temp / GRANT DBA TO SYSTEM WITH ADMIN OPTION / GRANT aq_administrator_role TO SYSTEM WITH ADMIN OPTION / GRANT UNLIMITED TABLESPACE TO SYSTEM WITH ADMIN OPTION / BEGIN dbms_resource_manager_privs.grant_switch_consumer_group( grantee_name => 'SYSTEM', consumer_group => 'SYS_GROUP', grant_option => FALSE ); END; /GRANT ALL ON INCEXP TO SYSTEM / GRANT ALL ON INCFIL TO SYSTEM / GRANT ALL ON INCVID TO SYSTEM / GRANT EXECUTE ON DBMS_ALERT TO SYSTEM / GRANT EXECUTE ON DBMS_AQ TO SYSTEM WITH ADMIN OPTION / GRANT EXECUTE ON DBMS_AQADM TO SYSTEM WITH ADMIN OPTION / GRANT EXECUTE ON DBMS_AQ_IMPORT_INTERNAL TO SYSTEM WITH ADMIN OPTION / GRANT EXECUTE ON DBMS_DEFER_IMPORT_INTERNAL TO SYSTEM / GRANT EXECUTE ON DBMS_REPCAT TO SYSTEM / GRANT EXECUTE ON DBMS_RULE_EXIMP TO SYSTEM WITH ADMIN OPTION / GRANT EXECUTE ON DBMS_SYS_ERROR TO SYSTEM / GRANT EXECUTE ON SYS_GROUP TO SYSTEM /
DEFAULT TABLESPACE SYSTEM
TEMPORARY TABLESPACE temp
/
GRANT DBA TO SYSTEM WITH ADMIN OPTION
/
GRANT aq_administrator_role TO SYSTEM WITH ADMIN OPTION
/
GRANT UNLIMITED TABLESPACE TO SYSTEM WITH ADMIN OPTION
/
BEGIN
dbms_resource_manager_privs.grant_switch_consumer_group(
grantee_name => 'SYSTEM',
consumer_group => 'SYS_GROUP',
grant_option => FALSE
);
END;
/GRANT ALL ON INCEXP TO SYSTEM
/
GRANT ALL ON INCFIL TO SYSTEM
/
GRANT ALL ON INCVID TO SYSTEM
/
GRANT EXECUTE ON DBMS_ALERT TO SYSTEM
/
GRANT EXECUTE ON DBMS_AQ TO SYSTEM WITH ADMIN OPTION
/
GRANT EXECUTE ON DBMS_AQADM TO SYSTEM WITH ADMIN OPTION
/
GRANT EXECUTE ON DBMS_AQ_IMPORT_INTERNAL TO SYSTEM WITH ADMIN OPTION
/
GRANT EXECUTE ON DBMS_DEFER_IMPORT_INTERNAL TO SYSTEM
/
GRANT EXECUTE ON DBMS_REPCAT TO SYSTEM
/
GRANT EXECUTE ON DBMS_RULE_EXIMP TO SYSTEM WITH ADMIN OPTION
/
GRANT EXECUTE ON DBMS_SYS_ERROR TO SYSTEM
/
GRANT EXECUTE ON SYS_GROUP TO SYSTEM
/