Password versions

SQL> select dbms_metadata.get_ddl('USER','TEST') from dual;




   CREATE USER "TEST" IDENTIFIED BY VALUES 'S:D9B62B388A0FE232B5AE09A051D2175C8F
493BF6797D415DEDB0A8B8BB2D;7A0F2B316C212D67'
      DEFAULT TABLESPACE "USERS"
      TEMPORARY TABLESPACE "TEMP"




SQL> select password, spare4 from sys.user$ where name='TEST';


7A0F2B316C212D67
S:D9B62B388A0FE232B5AE09A051D2175C8F493BF6797D415DEDB0A8B8BB2D




SQL> select password_versions from dba_users where username='TEST';


10G 11G


SQL> alter user test identified by values '7A0F2B316C212D67';


User altered.


SQL> select password, spare4 from sys.user$ where name='TEST';


7A0F2B316C212D67






SQL> select password_versions from dba_users where username='TEST';


10G


SQL> alter user test identified by values 'S:D9B62B388A0FE232B5AE09A051D2175C8F493BF6797D415DEDB0A8B8BB2D';


User altered.


SQL> select password, spare4 from sys.user$ where name='TEST';




S:D9B62B388A0FE232B5AE09A051D2175C8F493BF6797D415DEDB0A8B8BB2D




SQL> select password_versions from dba_users where username='TEST';


11G


SQL> conn test/test
Connected.
SQL> conn dba_user
Enter password:
Connected.
SQL> alter user test identified by values 'S:D9B62B388A0FE232B5AE09A051D2175C8F493BF6797D415DEDB0A8B8BB2D;7A0F2B316C212D67';


User altered.


SQL> select password_versions from dba_users where username='TEST';


10G 11G


SQL>