2013 m. balandžio 22 d., pirmadienis

ORACLE , kai userio password nežinomas, o reikia jo duomenų

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.