Not able to see password value in Oracle 11g

Many of us are habitual of resetting the user password by values. If you will fire the command in Oracle 11g and try to query DBA_USERS. You will find no values for password. See below.

SQL> select username,password from dba_users where username='SCOTT';

USERNAME                       PASSWORD
------------------------------ ------------------------------
SCOTT






To get the password value in Oracle 11g , you need to query USER$ table as given below.





SQL> select NAME,PASSWORD from SYS.USERS$ where name='SCOTT';

NAME                           PASSWORD
------------------------------ ------------------------------
SCOTT                          A654888Z34402S74





Now you can change the password using values.

Oracle 18c onwards,

SQL> select spare4 from sys.user$ where name='GSMUSER';

SPARE4
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S:D3258850C99652C76A8D12BB8F5764249179BCD83E2A94B8AE24D1E3EC65;T:3E0EF13A60C6511DA27BA714B9A99B5D77E94ADD2AB9E76A9C36F935DF8714DFF3E956756E49AEECD1C35AA949C8DE548264602AB6706B037BFE8A2378BEECA0D4330F8EE0B26E4B0792CDF0D5BB5D6A

SQL>alter user GSMUSER identified by values 'S:D3258850C99652C76A8D12BB8F5764249179BCD83E2A94B8AE24D1E3EC65;T:3E0EF13A60C6511DA27BA714B9A99B5D77E94ADD2AB9E76A9C36F935DF8714DFF3E956756E49AEECD1C35AA949C8DE548264602AB6706B037BFE8A2378BEECA0D4330F8EE0B26E4B0792CDF0D5BB5D6A';