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