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