Saving yourself a few seconds work when altering users.....



This will save you a few seconds every time you have to unlock/reset an oracle user...

For years I have been doing

alter user xxx identified by xxx;
alter user xxx account unlock;
alter user xxx password expire;

I guess because someone showed me that many years ago or that you maybe only have to run one of the commands above to fix any particular problem.


but.....

you can save yourself several seconds work by doing this

alter user xxxidentified by xxx password expire account unlock;

Pretty amazing ...... (or not as the case may be)

Anything to make life easier :-)

Comments