角色和权限

http://www.51testing.com/?16403/action_viewspace_itemid_86196.html

autotrace:
http://blog.csdn.net/huanghui22/archive/2006/10/08/1326227.aspx

http://blog.csdn.net/huanghui22/archive/2006/12/16/1445979.aspx

 

角色拥有的对象权限：

SQL> select * from dba_tab_privs where grantee like 'DBA' order by grantee,table_name;

GRANTEE                        OWNER                                           
------------------------------ ------------------------------                  
TABLE_NAME                     GRANTOR                                         
------------------------------ ------------------------------                  
PRIVILEGE                                GRA HIE                               
---------------------------------------- --- ---                               
DBA                            SYS                                             
AW$                            SYS                                             
DEBUG                                    NO  NO                                
                                                                               
DBA                            SYS                                             
AW$                            SYS                                             
SELECT                                   NO  NO                                                      
                                                                               
DBA                            SYS                                             
AWSEQ$                         SYS                                             
SELECT                                   NO  NO                                
                                                                               
DBA                            SYS                                             
AWSEQ$                         SYS                                                                      
ALTER                                    NO  NO                                
                                                                               
DBA                            SYS                                             
AW_OBJ$                        SYS                                             
DEBUG                                    NO  NO                                
                                                                               
DBA                            SYS                                                                          
AW_OBJ$                        SYS                                             
SELECT                                   NO  NO                                
                                                                               
DBA                            SYS                                             
AW_PROP$                       SYS                                             
SELECT                                   NO  NO                                
                                                                                                            
DBA                            SYS                                             
AW_PROP$                       SYS                                             
DEBUG                                    NO  NO                                
                                                                               
DBA                            SYS                                             
DBMS_DEFER_QUERY               SYS                                             
EXECUTE                                  NO  NO                                                         
                                                                               
DBA                            SYS                                             
DBMS_DEFER_SYS                 SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
DBMS_FEATURE_USAGE_REPORT      SYS                                                                          
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
DBMS_FLASHBACK                 SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                                                        
DBMS_LOGSTDBY                  SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
DBMS_MONITOR                   SYS                                             
EXECUTE                                  NO  NO                                
                                                                                                             
DBA                            SYS                                             
DBMS_RESUMABLE                 SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
DBMS_SERVER_ALERT              SYS                                             
EXECUTE                                  NO  NO                                                              
                                                                               
DBA                            SYS                                             
DBMS_SERVER_TRACE              SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
DBMS_SERVICE                   SYS                                                                           
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
DBMS_STORAGE_MAP               SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                                                         
DBMS_TDB                       SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
DBMS_UADV_ARR                  SYS                                             
EXECUTE                                  NO  NO                                
                                                                                                             
DBA                            SYS                                             
DBMS_UNDO_ADV                  SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
DBMS_WORKLOAD_CAPTURE          SYS                                             
EXECUTE                                  NO  NO                                                              
                                                                               
DBA                            SYS                                             
DBMS_WORKLOAD_REPOSITORY       SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
LOAD_UNDO_STAT                 SYS                                                                          
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
MAP_OBJECT                     SYS                                             
ALTER                                    NO  NO                                
                                                                               
DBA                            SYS                                                                          
MAP_OBJECT                     SYS                                             
DELETE                                   NO  NO                                
                                                                               
DBA                            SYS                                             
MAP_OBJECT                     SYS                                             
INSERT                                   NO  NO                                
                                                                                                           
DBA                            SYS                                             
MAP_OBJECT                     SYS                                             
SELECT                                   NO  NO                                
                                                                               
DBA                            SYS                                             
MAP_OBJECT                     SYS                                             
UPDATE                                   NO  NO                                                             
                                                                               
DBA                            SYS                                             
MAP_OBJECT                     SYS                                             
ON COMMIT REFRESH                        NO  NO                                
                                                                               
DBA                            SYS                                             
MAP_OBJECT                     SYS                                                                         
FLASHBACK                                NO  NO                                
                                                                               
DBA                            SYS                                             
MAP_OBJECT                     SYS                                             
DEBUG                                    NO  NO                                
                                                                               
DBA                            SYS                                                                          
MAP_OBJECT                     SYS                                             
QUERY REWRITE                            NO  NO                                
                                                                               
DBA                            SYS                                             
OUTLN_EDIT_PKG                 SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
                              
DBA                            SYS                                             
OUTLN_PKG                      SYS                                             
EXECUTE                                  NO  NO                                
                                                                               
DBA                            SYS                                             
PS$                            SYS                                             
SELECT                                   NO  NO                                
                             
                                                                               
DBA                            SYS                                             
PS$                            SYS                                             
DEBUG                                    NO  NO                                
                                                                               
DBA                            SYS                                             
RESET_UNDO_STAT                SYS                                                                            
EXECUTE                                  NO  NO                                
                                                                               

已选择39行。