Friday, July 4, 2014

LOGIN into DATABASE without PASSWORD

LOG IN into DATABASE without PASSWORD

sqlplus / as sysdba


SQL> SELECT password FROM dba_users WHERE  username='SCOTT';
PASSWORD
------------------------------
F894844C34402B67


SQL> ALTER USER scott IDENTIFIED BY abcdefg;
User altered.

SQL> CONNECT scott/abcdefg
Connected.


SQL> select * from scott.emp;


SQL> ALTER USER scott IDENTIFIED BY VALUES 'F894844C34402B67';
User altered.

SQL> conn scott/tiger
Connected.





No comments:

Post a Comment