拥有和SYSTEM相同的权限

-- 创建用户

create user NEWUSER123

  identified by "NEWUSER123"

  default tablespace SYSTEM

  temporary tablespace TEMP

  profile DEFAULT;

-- 连接到SYS用户下去授权

grant execute on SYS.DBMS_ALERT to NEWUSER123;

grant execute on SYS.DBMS_AQ to NEWUSER123 with grant option;

grant execute on SYS.DBMS_AQADM to NEWUSER123 with grant option;

grant execute on SYS.DBMS_AQELM to NEWUSER123 with grant option;

grant execute on SYS.DBMS_AQ_IMPORT_INTERNAL to NEWUSER123 with grant option;

grant execute on SYS.DBMS_DEFER_IMPORT_INTERNAL to NEWUSER123;

grant execute on SYS.DBMS_REPCAT to NEWUSER123;

grant execute on SYS.DBMS_RULE_EXIMP to NEWUSER123 with grant option;

grant execute on SYS.DBMS_SQL to NEWUSER123;

grant execute on SYS.DBMS_SYS_ERROR to NEWUSER123;

grant execute on SYS.DBMS_SYS_SQL to NEWUSER123;

grant execute on SYS.DBMS_TRANSFORM_EXIMP to NEWUSER123 with grant option;

grant select, insert, update, delete, references, alter, index on SYS.INCEXP toNEWUSER123;

grant select, insert, update, delete, references, alter, index on SYS.INCFIL toNEWUSER123;

grant select, insert, update, delete, references, alter, index on SYS.INCVID toNEWUSER123;

grant execute on SYS.SYS_GROUP to NEWUSER123;

grant select on WMSYS.WM$UDTRIG_INFO to NEWUSER123;

grant aq_administrator_role to NEWUSER123 with admin option;

grant dba to NEWUSER123 with admin option;

grant sales_history_role to NEWUSER123 with admin option;

grant students to NEWUSER123 with admin option;

grant unlimited tablespace to NEWUSER123 with admin option;