Disclaimer

Friday, 1 October 2021

How to reset password with knowing user password in Oracle Database

SQL> select username,account_status from dba_users where username='SAMIK';
USERNAME        ACCOUNT_STATUS
------------   -----------
SAMIK          EXPIRED

SQL> select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c from dba_users d, sys.user$ u where d.username = upper('&&username') and u.user# = d.user_id;
Enter value for username: SAMIK
old 1: select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c from dba_users d, sys.user$ u where d.username = upper('&&username') and u.user# = d.user_id
new 1: select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c from dba_users d, sys.user$ u where d.username = upper('SAMIK') and u.user# = d.user_id
C
-------------------------------------------------------------------------------------
alter user "SAMIK" identified by values 'D1335553276FBC0B';
SQL>
SQL>
SQL> alter user "SAMIK" identified by values 'D1335553276FBC0B';

User altered.


SQL> select username,account_status from dba_users where username='SAMIK';
USERNAME        ACCOUNT_STATUS
------------   -----------
SAMIK          OPEN

User altered.



No comments:

Post a Comment

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...