10g 10.2.1.0 

select * from dba_roles;

CONNECT                                                               創(chuàng)建session角色
RESOURCE                                                            創(chuàng)建資源角色,Create table 等等
DBA                                                                           數(shù)據(jù)庫管理員角色
SELECT_CATALOG_ROLE                                 查看數(shù)據(jù)字典角色
EXECUTE_CATALOG_ROLE                              執(zhí)行數(shù)據(jù)字典中部分函數(shù)的角色
DELETE_CATALOG_ROLE                                 刪除sys.adu$記錄的角色
EXP_FULL_DATABASE                                        全庫導(dǎo)出角色
IMP_FULL_DATABASE                                         全庫導(dǎo)入角色
RECOVERY_CATALOG_OWNER                      備份目錄的擁有者 RMAN使用    
GATHER_SYSTEM_STATISTICS      
LOGSTDBY_ADMINISTRATOR         
AQ_ADMINISTRATOR_ROLE                             高級隊列管理員角色
AQ_USER_ROLE                                                  高級隊列使用者角色
GLOBAL_AQ_USER_ROLE              
SCHEDULER_ADMIN                                           調(diào)度管理者角色
HS_ADMIN_ROLE                                
AUTHENTICATEDUSER                    
OEM_ADVISOR                                    
OEM_MONITOR                                   
WM_ADMIN_ROLE                               
JAVAUSERPRIV                                   
JAVAIDPRIV                    
JAVASYSPRIV                   
JAVADEBUGPRIV                 
EJBCLIENT                     
JAVA_ADMIN                    
JAVA_DEPLOY                   
CTXAPP                        
XDBADMIN                      
XDBWEBSERVICES               
OLAP_DBA                      
OLAP_USER                     
MGMT_USER