system 不仅仅有DBA角色的权限,而且还有其他权限. 使用sys用户进行授权相关的权限在dba_role_privs表中去找select t.granted_role from dba_role_privs t where t.grantee='SYSTEM';大概有如下三个:AQ_ADMINISTRATOR_ROLE DBA MGMT_USER分别grant 就ok了
CREATE USER XXX IDENTIFIED BY XXX;GRANT AQ_ADMINISTRATOR_ROLE TO XXX; GRANT DBA TO XXX; GRANT MGMT_USER TO XXX;
使用sys用户进行授权相关的权限在dba_role_privs表中去找select t.granted_role from dba_role_privs t where t.grantee='SYSTEM';大概有如下三个:AQ_ADMINISTRATOR_ROLE
DBA
MGMT_USER分别grant 就ok了
GRANT DBA TO XXX;
GRANT MGMT_USER TO XXX;