Skip to Main Content

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!

Find out OS user who locked an account

user650888Oct 23 2025

In production, we are seeing randomely database schema accounts being locked

I want to know which os user / machine name locked a schema ABC in database DB_PROD (example names)

can I use DBA_AUDIT_SESSION to idenfity the os user / machine name that locked the account?

Comments
Post Details
Added on Oct 23 2025
2 comments
106 views