查看用户对象权限到excel
-
wzgchen
2016-01-21 11:32:52
-
Oracle
-
原创
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;