Get Bad Login Attempts in Oracle

If you want to audit your database to see when and where bad login attempts are happening, you can run the query below:

select *
from dba_audit_trail
where returncode = 1017;

Here are a few other return codes you can check for:

Return Codes #

• Next: Copying Data From an .xls File to an .xlsx file with Python
• Previous: Get the Session and Database Timezone Offset in Oracle