Using Oracle 11.2.0.4:
What is the easiest way to setup and create a "temporary" account in the database for someone.
In our case, I want to create an account that will lock in 60 days.
I was thinking of setting the PASSWORD_LIFE_TIME to expire in 60 days, and then set the password_verify_function to something that would basically make the password impossible to meet the criteria, but I'm not sure how to do that with that package from Oracle.
I thought of setting up an onlogon trigger to check if the sysdate is some date 60 days from now, and if so, the lock the account.
But I was wondering if there was an easier way to do it when creating the user account.
I do not want to create an externally authenticated account.