Tuesday 4 August 2015

ORA-28001: the password has expired

In order to re-enable the schema owner you can run the following SQL:
ALTER USER <username> IDENTIFIED BY <new_password>;
Another way to re-enable the schema owner can be done with brconnect:
brconnect -u system/<password> -f chpass -o <username> -p <password>


No comments:

Post a Comment