How to have oracle automatically lock an account after 10 minutes ?
Hi
I am setting up a special audited schema in my production DB that will be unlocked per request to enable users to perform certain operations.
I want the account to automatically lock after 10 minutes.
What is the best way to accomplish that ?
remember - a dbms_job or a cronjob that will run every 10 minutes and lock the account is not good - because that could be 2 minutes after it was unlocked.
it needs to be locked 10 minutes AFTER it was locked.
One option I thought about is to set a dbms_job that will look at the aud$ table every minute ( since this schema is audited ) and will check the last LOGON operation to this account
and if it passed 10 minutes - to lock it
Any other suggestions ? maybe something that is already implemented as an option and does not require coding ?
Orna