oracle 11g中有多少角色：
SQL> select * from dict where table_name='DBA_ROLES';

TABLE_NAME
------------------------------
COMMENTS
------------------------------------------------------
------------------------------------------------------
DBA_ROLES
All Roles which exist in the database

SQL> select * from dba_roles;

ROLE                           PASSWORD
------------------------------ --------
CONNECT                        NO
RESOURCE                       NO
DBA                            NO
SELECT_CATALOG_ROLE            NO
EXECUTE_CATALOG_ROLE           NO
DELETE_CATALOG_ROLE            NO
EXP_FULL_DATABASE              NO
IMP_FULL_DATABASE              NO
LOGSTDBY_ADMINISTRATOR         NO
AQ_ADMINISTRATOR_ROLE          NO
AQ_USER_ROLE                   NO

ROLE                           PASSWORD
------------------------------ --------
DATAPUMP_EXP_FULL_DATABASE     NO
DATAPUMP_IMP_FULL_DATABASE     NO
GATHER_SYSTEM_STATISTICS       NO
RECOVERY_CATALOG_OWNER         NO
SCHEDULER_ADMIN                NO
HS_ADMIN_ROLE                  NO
GLOBAL_AQ_USER_ROLE            GLOBAL
OEM_ADVISOR                    NO
OEM_MONITOR                    NO
WM_ADMIN_ROLE                  NO
JAVAUSERPRIV                   NO

ROLE                           PASSWORD
------------------------------ --------
JAVAIDPRIV                     NO
JAVASYSPRIV                    NO
JAVADEBUGPRIV                  NO
EJBCLIENT                      NO
JMXSERVER                      NO
JAVA_ADMIN                     NO
JAVA_DEPLOY                    NO
CTXAPP                         NO
XDBADMIN                       NO
XDB_SET_INVOKER                NO
AUTHENTICATEDUSER              NO

ROLE                           PASSWORD
------------------------------ --------
XDB_WEBSERVICES                NO
XDB_WEBSERVICES_WITH_PUBLIC    NO
XDB_WEBSERVICES_OVER_HTTP      NO
SPATIAL_WFS_ADMIN              YES
ORDADMIN                       NO
OLAPI_TRACE_USER               NO
OLAP_XS_ADMIN                  NO
OLAP_DBA                       NO
CWM_USER                       NO
OLAP_USER                      NO
WFS_USR_ROLE                   YES

ROLE                           PASSWORD
------------------------------ --------
SPATIAL_CSW_ADMIN              YES
CSW_USR_ROLE                   YES
WKUSER                         NO
MGMT_USER                      NO
OWB$CLIENT                     YES
OWB_DESIGNCENTER_VIEW          YES
OWB_USER                       NO

已选择51行。

每个角色的系统权限是什么？两种方法，不同的数据字典。
SQL> select * from dba_sys_privs where grantee='RESOURCE';---大写权限名字

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
RESOURCE                       CREATE TRIGGER                           NO
RESOURCE                       CREATE SEQUENCE                          NO
RESOURCE                       CREATE TYPE                              NO
RESOURCE                       CREATE PROCEDURE                         NO
RESOURCE