Hesla jsou v databázi zašifrovaná, takže stávající heslo nezjistíte, ale můžete zjistit HASH a ten pak nastavit přímo.
SQL> select USERNAME, ACCOUNT_STATUS, EXPIRY_DATE from dba_users where username='ADMIN';
USERNAME ACCOUNT_STATUS EXPIRY_D ------------------------------ -------------------------------- -------- ADMIN EXPIRED 20.01.15
SQL> SELECT DBMS_METADATA.get_ddl ('USER', 'ADMIN') FROM DUAL;
DBMS_METADATA.GET_DDL('USER','ADMIN') --------------------------------------------------------------------------------
CREATE USER "ADMIN" IDENTIFIED BY VALUES '637B29B4423ECEF8' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" PASSWORD EXPIRE
SQL> ALTER USER "ADMIN" IDENTIFIED BY VALUES '637B29B4423ECEF8';
Uzivatel zmenen.
SQL> select USERNAME, ACCOUNT_STATUS, EXPIRY_DATE from dba_users where username='ADMIN';
USERNAME ACCOUNT_STATUS EXPIRY_D ------------------------------ -------------------------------- -------- ADMIN OPEN 27.04.15