查看用户对象权限到excel


Oracle用户对象权导入到excel
set line 1000        
set pagesize 0       
set feedback off      
set heading off       
set trimspool on     
set trims on         
set echo off;      
set colsep ','        
set termout off       
spool /tmp/tpriv.csv;  
select GRANTEE,TABLE_NAME,WMSYS.WM_CONCAT(PRIVILEGE) from user_tab_privs where grantee in ('xxx1','xxx2','xxx3','xxx4') group by GRANTEE,TABLE_NAME order by grantee;
spool off;
请使用浏览器的分享功能分享到微信等