LOG IN into DATABASE without PASSWORD
sqlplus / as sysdba
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