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
Post a Comment