Skip to content
Advertisements

Archive for

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.

Advertisements