建用户脚本

最新推荐文章于 2024-11-07 19:41:58 发布

jisen_huang

最新推荐文章于 2024-11-07 19:41:58 发布

阅读量399

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle 文章标签：建立用户脚本

本文链接：https://blog.youkuaiyun.com/jisen_huang/article/details/39023199

oracle 专栏收录该内容

65 篇文章

订阅专栏

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:\2cusr.sql
select 'create user ' ||username|| ' identified by ' ||username|| ' default tablespace ' ||DEFAULT_TABLESPACE|| ' temporary tablespace ' ||TEMPORARY_TABLESPACE|| ' QUOTA UNLIMITED ON '||DEFAULT_TABLESPACE||';'
from
dba_users where username 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 username;
spool off