Skip to Main Content

Oracle Database Discussions

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!

Finding out who is locking account in database

652811Dec 29 2009 — edited Dec 29 2009
Hi Gurus,

Need help out for some investigation .

We have one user created in database and it is shared with only DBAs. From last one month, account is getting

locked and we need to do again unlock. We don't want to set any audit parameter or trigger to capture.

Is there any generic way to find out from views who has locked and when it was ?


Thanks & Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2010
Added on Dec 29 2009
8 comments
11,963 views