select *
from role_tab_privs t1
where t1.role = 'DBA'
ROLE OWNER TABLE_NAME COLUMN_NAME PRIVILEGE GRANTABLE
DBA SYS AW$ SELECT NO
DBA SYS MAP_OBJECT INSERT NO
DBA SYS DBMS_LOGSTDBY EXECUTE NO
DBA SYS DBMS_SERVER_ALERT EXECUTE NO
DBA SYS DBMS_DEFER_SYS EXECUTE NO
DBA SYS DBMS_RESUMABLE EXECUTE NO
DBA SYS PS$ DEBUG NO
DBA SYS AWSEQ$ SELECT NO
DBA SYS AW_PROP$ DEBUG NO
DBA SYS MAP_OBJECT ON COMMIT REFRESH NO
DBA SYS MAP_OBJECT UPDATE NO
DBA SYS MAP_OBJECT SELECT NO
DBA SYS MAP_OBJECT DELETE NO
DBA SYS DBMS_SERVER_TRACE EXECUTE NO
DBA SYS LOAD_UNDO_STAT EXECUTE NO
DBA SYS DBMS_FEATURE_USAGE_REPORT EXECUTE NO
DBA SYS AW_PROP$ SELECT NO
DBA SYS OUTLN_PKG EXECUTE NO
DBA SYS DBMS_MONITOR EXECUTE NO
DBA SYS AW$ DEBUG NO
DBA SYS AW_OBJ$ DEBUG NO
DBA SYS AW_OBJ$ SELECT NO
DBA SYS MAP_OBJECT ALTER NO
DBA SYS DBMS_TDB EXECUTE NO
DBA SYS OUTLN_EDIT_PKG EXECUTE NO
DBA SYS RESET_UNDO_STAT EXECUTE NO
DBA SYS PS$ SELECT NO
DBA SYS DBMS_STORAGE_MAP EXECUTE NO
DBA SYS DBMS_WORKLOAD_REPOSITORY EXECUTE NO
DBA SYS AWSEQ$ ALTER NO
DBA SYS DBMS_SERVICE EXECUTE NO
DBA SYS DBMS_UADV_ARR EXECUTE NO
DBA SYS MAP_OBJECT QUERY REWRITE NO
DBA SYS DBMS_DEFER_QUERY EXECUTE NO
DBA SYS DBMS_WORKLOAD_CAPTURE EXECUTE NO
DBA SYS MAP_OBJECT FLASHBACK NO
DBA SYS MAP_OBJECT DEBUG NO
DBA SYS DBMS_FLASHBACK EXECUTE NO
DBA SYS DBMS_UNDO_ADV EXECUTE NO
10.查看赋给用户(GDYXHD)对对象操作的一些权限
select *
fromtable_privileges t1
where t1.grantee = 'GDYXHD'
GRANTEE OWNER TABLE_NAME GRANTOR SELECT_PRIV INSERT_PRIV DELETE_PRIV UPDATE_PRIV REFERENCES_PRIV ALTER_PRIV INDEX_PRIV CREATED
GDYXHD SYS DUMP_FILE_DIR SYS N N N N N N N
上面的DUMP_FILE_DIR是一个目录对象