重庆思庄Oracle、Redhat认证学习论坛

标题: oracle抓取用户密码语句 [打印本页]

作者: mahan 时间: 6 天前
标题: 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;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)