SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Procedure to lock user who has not logged for specific days

user8983130Jun 16 2015 — edited Aug 10 2015

Dear,

I need to write a procedure , which will lock user who has not logged in the db for the last 45 days. I have enabled session auditing in my db. Which means , it will have NTIMESTAMP# column for the login time and action# 100 for login event in the AUD$ table.

How can the procedure be written so that it could only locked the right user. Please help me..

Regards,

This post has been answered by Jonathan Lewis on Aug 10 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2015

Added on Jun 16 2015

24 comments

3,719 views