重庆思庄技术分享——oracle抓取用户密码语句

oracle抓取用户密码语句
1，抓取数据库用户密码语句
spool user_create.sql
select 'create user ' || username || ' identified by values' || '''' ||
b.password || '''' || ' default tablespace ' || default_tablespace ||
' temporary tablespace ' || temporary_tablespace || ';'
from dba_users a, sys.user$ b
where username = 'USERNAME'
and a.username = b.name;
spool off;