identified by values

admin

1. set lines 500 pages 500
   
2. set long 99999999
   
3. SELECT dbms_metadata.get_ddl('USER','&username') FROM dual;

复制代码

12以上版本：

1. DBMS_METADATA.GET_DDL('USER','SYSTEM')
   
2. --------------------------------------------------------------------------------
   
3. 
   
4. ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'S:D7F8228B3FA92E043940B2214B44E2E6D
   
5. 2213AA29AE53F32A2930DEF8036;T:C14E525F4B8DA2D243043DE2370E7DDC3D8CA6CCF8A7AFED27
   
6. 7594F402EF6B839771E9886188723A485813A6D5981A54A3D24FD41308281DAC1FE5363103961218
   
7. CF72351B0C855FB8DDFE79F7CE4FEC'
   
8. TEMPORARY TABLESPACE "TEMP"

复制代码

1. alter user system identified by values 'S:D7F8228B3FA92E043940B2214B44E2E6D2213AA29AE53F32A2930DEF8036;T:C14E525F4B8DA2D243043DE2370E7DDC3D8CA6CCF8A7AFED277594F402EF6B839771E9886188723A485813A6D5981A54A3D24FD41308281DAC1FE5363103961218CF72351B0C855FB8DDFE79F7CE4FEC';

复制代码

11版本
zhyu密码是zhangyu,可以正常连接

1. [oracle@vm1 ~]$ sqlplus zhyu/zhangyu

复制代码

by values值如下

1. [oracle@vm1 ~]$ sqlplus / as sysdba
   
2. DBMS_METADATA.GET_DDL('USER','ZHYU')
   
3. --------------------------------------------------------------------------------
   
4.    CREATE USER "ZHYU" IDENTIFIED BY VALUES 'S:467A95BA9F9F1D594BA848268605048E03
   
5. 026803FFC328B23C5C1E6CB89F;CAFAC641F13CA7E3'
   
6.       DEFAULT TABLESPACE "USERS"
   
7.       TEMPORARY TABLESPACE "TEMP"

复制代码

密码版本如下

1. SYS@ora11> select username,password_versions from dba_users;
   
2. USERNAME               PASSWORD
   
3. ------------------------------ --------
   
4. SYS                   10G 11G
   
5. SYSTEM                   10G 11G
   
6. ZHYU                   10G 11G

复制代码

删除用户，用by values重建，用明文密码链接正常

1. SYS@ora11> drop user zhyu cascade;
   
2. SYS@ora11> create user zhyu identified by values 'S:467A95BA9F9F1D594BA848268605048E03026803FFC328B23C5C1E6CB89F;CAFAC641F13CA7E3';
   
3. SYS@ora11> grant connect,resource to zhyu;
   
4. [oracle@vm1 ~]$ sqlplus zhyu/zhangyu
   
5. ZHYU@ora11>

复制代码

11gto12c版本
12c明文密码新建用户密码版本是12

1. SYS@ora19> create user zhyu identified by zhangyu;
   
2. SYS@ora19> select username,password_versions from dba_users;
   
3. USERNAME               PASSWORD_VERSIONS
   
4. ------------------------------ -----------------
   
5. ZHYU                   12C
   
6. 
   
7.    CREATE USER "ZHYU" IDENTIFIED BY VALUES 'T:2CD2DAFFCAB7554B523339AA08E17F79D1
   
8. FCA84E15BA0E504AA611825159BB5062C2FC11B65318B7F9C569EA367DD6D8F2F2BAAA052CB237B1
   
9. ABE87E786589C3A56029B64C5DB9E17B04CD65D64BF049'
   
10.       DEFAULT TABLESPACE "USERS"
    
11.       TEMPORARY TABLESPACE "TEMP"
    

复制代码

12c使用11g的加密密码新建用户密码版本是10g11g

1. SYS@ora19> create user zhyu identified by values 'S:467A95BA9F9F1D594BA848268605048E03026803FFC328B23C5C1E6CB89F;CAFAC641F13CA7E3';
   
2. 
   
3. SYS@ora19> col username for a30
   
4. SYS@ora19> select username,password_versions from dba_users;
   
5. 
   
6. USERNAME                       PASSWORD_VERSIONS
   
7. ------------------------------ -----------------
   
8. ZHYU                               10G 11G
   

复制代码