unlock and unexpire oracle accounts through script
Posted on 2009-04-13
I like to create a small unix shell script to unlock and unexpire all the expired and locked user accounts.
the above command has to unlock and unexpire the expired and locked user accounts
i like a interaction script also,
then it has to ask like this for all users who's account is locked and expired.
ABC account is locked.
Do you want to unlock ? - waiting for user input ( if it is y then it should unlock)
ABC account is expired.
Do you want to unexpire ? - waiting for user input ( if it is y then it should unlock)
Any idea how to implement this.