建立 grant 用户权限脚本

最新推荐文章于 2024-04-15 23:55:43 发布

黄继生 jisen

最新推荐文章于 2024-04-15 23:55:43 发布

阅读量570

点赞数

分类专栏： oracle 文章标签： grant 用户权限脚本

本文链接：https://blog.csdn.net/jisen_huang/article/details/39023221

版权

oracle 专栏收录该内容

65 篇文章 4 订阅

订阅专栏

set echo off;
set feedback off;
set colsep |;
set linesize 2500;
set pagesize 0;
set heading off;
set term off;
set trimspool on;
set trimout on;
set numformat 99999999990.99;
set sqlnumber off;

spool D:\3gusr.sql

select 'grant ' || GRANTED_ROLE || ' to ' || GRANTEE || ';' from dba_role_privs where GRANTEE not in ('HR','ODM','ODM_MTR','OE','PM','QS','QS_ADM','QS_CB','QS_CBADM','QS_CS','QS_ES','QS_OS','QS_WS','RMAN','SH','WKPROXY','WKSYS','MGMT_VIEW','SYSTEM','DBSNMP','SYSMAN','OUTLN','MDSYS','ORDSYS','CTXSYS','ANONYMOUS','EXFSYS','DMSYS','WMSYS','XDB','ORDPLUGINS','SI_INFORMTN_SCHEMA','OLAPSYS','MDDATA','DIP','SCOTT','TSMSYS','SYS') order by GRANTEE;

spool off