Lock/Deactivate account using PROFILE, if not used for 30 days

Hello,
    Using Profile, I want to disable/deactivate/lock an Oracle user ID If not used for 30 days.
    Is it possible using Profile? If not any other option to accomplish the same?

 Thanks
LVL 1
oracopAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
sdstuberConnect With a Mentor Commented:
the profile itself won't disable the account but you can turn on auditting and then use a dbms_job or dbms_scheduler process to monitor dba_audit_trail and deactivate any accounts that show no recent activity.
0
All Courses

From novice to tech pro — start learning today.