Change Oracle password temporarily
I just want to share about How to change Oracle username password temporarily.Because this steps may use for application devlopment without conflict old password if you’re forgotten or If you’re not creator of the users.But condition apply If any limit resource password function applicable.
Step 1: Create user and password. Conn as a sys user.
SQL> create user test identified by test;
User created.
SQL> grant connect,resource to test;
Grant succeeded.
Step 2:
SQL> select username,password from dba_users where username =’TEST’;
USERNAME PASSWORD
—————————— ——————————
TEST 7A0F2B316C212D67
Step 3:
SQL> conn test/test@azar;
Connected.
SQL> conn sys/sys@azar as sysdba
Connected.
Step 4:
SQL> alter user test identified by test123;
User altered.
SQL> conn test/test123@azar;
Connected.
Step 5:
SQL> conn sys/sys@azar as sysdba
Connected.
SQL> alter user test identified by values ‘7A0F2B316C212D67’;
User altered.
SQL> conn test/test@azar;
Connected.