3 Replies Latest reply: Jan 30, 2013 10:31 AM by Osama_Mustafa RSS

    regarding user password query

    user11221081
      hi guys

      actually i want to get the details of password of my users in database.but when i run below commands i am unable to see any hash value of password.

      AS I have mu user wr with password set for it but when i query it does not show hast value

      my oracle version is 11.2.0.1. on aix 6

      select 'create user '||username||' identified by values '||''''||password||
      '''||' default tablespace '||default_tablespace||' temporary tablespace temp ;'
      from dba_users where username like '%LIMS%'
      order by username;


      create user WCR identified by values '' default tablespace USERS temporary table
      space temp ;

      also if i fire

      SQL> SELECT USERNAME,PASSWORD FROM DBA_USERS where username in ('WR');

      USERNAME PASSWORD
      ------------------------------ ------------------------------
      WR

      IT shows null in password

      please clarify