I am trying to set PASSWORD_LIFE_TIME to unlimited on my databases but have a problem. I am running the following SQL commands;
conn / as sysdba
alter user <user> account unlock;
alter user <user> identified by <password>;
commit;
alter profile default limit password_life_time unlimited;
commit;
The problem that I have is that when unlocking and resetting the password of <user> it works OK, but when trying to update the default profile, <user> suddenly becomes <USER> and so the changes don't take effect.