Connect as Administrator to Windows server.
Administrator must be in ORA_DBA group.
1.
SQL: CONNECT / as sysdba
Connected.
2.
SQL: SELECT password FROM dba_users WHERE username='SCOTT';
PASSWORD
---------------
F894844C34402B67
3.
SQL: ALTER USER scott IDENTIFIED BY anything;
User altered.
4.
Jungiames su nauju, kažką padarome...
SQL: CONNECT scott/anything
Connected.
5.
OK, we're in. Let's quickly change the password back before anybody notices.
SQL: ALTER USER scott IDENTIFIED BY VALUES 'F894844C34402B67';
User altered.
Komentarų nėra:
Rašyti komentarą