zaterdag 19 augustus 2017

Oracle XE expired password

sqlplus /nolog
SQL> connect / as SYSDBA
Connected
SQL>


select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%EXPIRED%';

ALTER USER theusername IDENTIFIED BY thepassword;

ALTER USER theusername ACCOUNT UNLOCK;

Geen opmerkingen:

Een reactie posten