<\/p>\n
If you have DBA privileges, you can connect with that user without knowing a user’s password, then you can set the old password. In this way, the user will not understand that someone else is connected to his \/ her account. You do not need to connect as sysdba for this operation.<\/p>\n
First of all, we will detect the user’s password in an encrypted way. The area that we will use in the future will be the information in the PASSWORD column.<\/p>\n
SQL> SELECT name, password, spare4 FROM sys.user$ WHERE name='SCOTT';\r\n\r\nNAME PASSWORD SPARE4\r\n------------------------------ ------------------------------ \r\nSCOTT F9CEE3031292BF07 S:5B3EBB444A10F303D08B160993C2AFF33C7184122F86EF258AD4CC2467A1<\/pre>\n<\/p>\n
Let’s change the user’s password with a password we want.<\/p>\n
SQL> alter user SCOTT identified by \"Welcome1\";\r\n\r\nUser altered.\r\n\r\n\r\nSQL> exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\nYou have new mail in \/var\/spool\/mail\/oracle<\/pre>\n<\/p>\n
Now we can connect to the database with the user we change the password and we can perform the operation we want.<\/p>\n
[oracle@orcldb ~]$ sqlplus SCOTT\/Welcome1@ORCL\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 28 16:31:12 2016\r\n\r\nCopyright (c) 1982, 2011, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\r\nSQL> create table deneme(id number,name varchar(30));\r\n\r\nTable created.\r\n\r\nSQL> insert into deneme values (1,'Ahmet');\r\n\r\n1 row created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> show user\r\nUSER is \"SCOTT\"\r\nSQL> exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options<\/pre>\n<\/p>\n
We re-set the old password with the following script. You should write the the old password’s spare value instead of\u00a0\u00a0S:5B3EBB444A10F303D08B160993C2AFF33C7184122F86EF258AD4CC2467A1<\/p>\n
[oracle@orcldb ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 28 16:32:54 2016\r\n\r\nCopyright (c) 1982, 2011, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\r\nSQL> alter user SCOTT identified by values 'S:5B3EBB444A10F303D08B160993C2AFF33C7184122F86EF258AD4CC2467A1';\r\n\r\nUser altered.\r\n\r\n\r\nSQL> exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options<\/pre>\nThe user will not be able to connect with the old password when we do this.<\/p>\n\n
<\/div>\n